Thread: Cannot get VALUE function to work with cell references
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Plog Michael Plog is offline
external usenet poster
  
Posts: 3
Default Cannot get VALUE function to work with cell references
I have a spreadsheet that has numbers entered as text. (I don't know
why they did it!) I want to convert these to numeric values so I can
sort properly, add, etc. When I use =value(L2) I get an error. Can
anyone help?

Thanks,
Michael Plog



Reply With QuoteReply With Quote