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?
|