Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
Ollie
It is not all that uncommon for users to check that box and set to 2 decimal places thinking that is the setting for showing the number of decimal places in an entered number. i.e. enter 1234.56789 and see 1234.57 The setting for that is actually found under FormatCellsNumberNumber Gord On 16 Oct 2005 04:46:48 -0700, wrote: Question is; why didn't I just look there in the first place, myself? Sheer laziness I suppose! You get so used to computers working quickly and accurately that when somthing goes wrong....well, you just get angry and frustrated! Again, thanks! Ollie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) |