View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Treehugger Treehugger is offline
external usenet poster
 
Posts: 3
Default Can General format numbers be mistaken as text?

My spreadsheet has several data input cells. The data is later used in a
calculation. I don't want the input restricted by format or number of
decimal points. I want the spreadsheet to display whatever the user types, so
I used the General format. A co-worker is concerned that Excel may misread
the numbers as text values unless they are specifically formatted as numbers.
Is this possible?