| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format Incorrect
Thank you all very much. It worked!
-- Linda "RagDyeR" wrote: <Tools <Options <Edit tab, And *UNCHECK* "Fixed Decimal Places" -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Linda" wrote in message ... Prior to today, this has not been a problem. When I enter a number (formatted as number, 0 decimals), the last two digits are not showing. i.e. entered 10500, the number shown in the cell is 105 i.e. entered 10511, the number shown in the cell is 105 Using General format, enter 10511, the number shown is 105.11 How do I correct so the number shown is correct. -- Linda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Number format for Combobox | Excel Discussion (Misc queries) | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
