| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup return NA for numbers format as general | Excel Worksheet Functions | |||
| Format: General - Text - General | Excel Worksheet Functions | |||
| excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| typing mistaken for date format | Excel Worksheet Functions | |||
Threaded Mode
