View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandi Sandi is offline
external usenet poster
 
Posts: 42
Default Numbers disguised as Text - Sorting Delima

I have a spreadsheet where it appears there are numbers in column A. To my
surprise they are acutally represented as text. I used the =isnumber formula
to test which came back false. What i need to do is convert these alpha
numbers to actual text in order to sort. Is there a way to do this?
--
Sandi Gardner