| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data entry error
When entering numbers, excel divides the entry by 10, so that by typing in
"220000", the cell contents become "22000". Reformatting the cell then has no effect on the contents of the cell, changing it to "22,000" for example. The error does not occur if you type either a comma separator or a decimal at the end of the numerical entry. Is there any known fix for this? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| create a data entry form template in Excel 2003? | Excel Discussion (Misc queries) | |||
| Translaton Error when importing Excel data into Outlook? | Excel Discussion (Misc queries) | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Threaded Mode
