| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding on Entry
When I enter "2446921240995606" in a cell formatted as a number
and hit enter, the last digit is altered to a zero. the result I get is "2446921240995600". Is there a way to keep it from being changed without formatting it as text? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| Highlight Duplicate on entry | Setting up and Configuration of Excel | |||
| How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
| double-clicking a list entry | Excel Discussion (Misc queries) | |||
Threaded Mode
