| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Numbers typed into Excel 2003 read as whole numbers
Good Thursday Afternoon,
When I type a decimal value into a cell in an Excel 2003 spreadsheet the formula bar shows the value as a whole number ( not a decimal ) even though the cell shows a decimal. Worse, calculations are preformed with the whole number. I have tried changing cell formatting to General, Number and even Custom but the value is still read as a whole number, not the decimal I typed in. Any thoughts or help by those wiser than I would be appreciated. Thanks in advance. :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| excel puts dates instead of numbers when typed | Excel Worksheet Functions | |||
| typed numbers entered in cell wrong | Excel Discussion (Misc queries) | |||
| Can numbers be typed to automatically be negative in cells? | New Users to Excel | |||
| How do I get numbers on a colum to stay as I typed them on an exc. | Excel Discussion (Misc queries) | |||
Threaded Mode
