View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
a m spock a m spock is offline
external usenet poster
 
Posts: 50
Default number not recognised

i have received a spreadsheet in which some numbers appear to be entered as
text. i have tried the =value(text) function but am not able to convert them
back to numbers. please help.