Thread: [Solved] Cannot Convert Text Cell to number format to be able to sort the data
View Single Post
 
Old 06-18-2013, 05:33 PM
jyfuller jyfuller is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Jun 2012
Posts: 32
jyfuller is on a distinguished road
Default
I have attached the file again. I tried what you said and it is still not sorting. When it sorts it sorts to 0 and then back up. wierd.....

It says it is a numeric value but when I multiply by 1 I get #value. I am really confused please help.
Attached Files
File Type: xlsx Numbers 2.xlsx (24.7 KB, 6 views)
Last edited by jyfuller; 06-18-2013 at 09:55 PM.
Reply With Quote