| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Number format still uses decimal point
I have Excel 2002 SP3 and when I format cells to use numbers all numbers
show up with a decimal and then are rounded up. For example. I want to put inventory numbers in column A such as number 394. The result is that the number shows up in the formula bar as three POINT nine four and in column A as a 4. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show decimal point only if not a whole number | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
| format inplied decimal point | Excel Discussion (Misc queries) | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
Threaded Mode
