Text/Value Problem 3

[Texanite]

I have a column of numbers and some are text and some are values. Have tried everything to turn the text numbers into values (tried cut & past values and tried =value) and nothing seems to work. Am trying to sort on that column and until I can resolve this problem, it won't sort correctly... it keeps putting the text numbers at the bottom.

Thanks,
Texanite

 

[bluedragon2]

Make a column the same size as yours with all 1's in it. Then highlite your original column and do a copy, then highlite your '1' column and do a paste special and choose multilpy.



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[KenWright]

Hi Blue - You can also just copy a single empty cell (Not one formatted as text though), select the offending column and do Paste Special / Add. Saves all the 1s.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------