N
NCAMA
I am typing in for example 564.00 and it takes away my decimal and leaves 564.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mortgagesrus
Highlight the cells you want to format. Right click and select "format
cells", select number tab, select number and set the number of decimal places
you want.
Robert
cells", select number tab, select number and set the number of decimal places
you want.
Robert
M
Malcolm Graham
I think you need to format the cells.
FORMAT --> CELLS then choose "Number" or "Currency" or "Accounting" and you
can specify how many decimals you want to display.
REMEMBER if you enter 10.555 but display only 2 decimals, Excel will show
10.56 but the actual value of the cell will be 10.555. (can cause confusion
when adding a column of numbers.
Hope this helps
FORMAT --> CELLS then choose "Number" or "Currency" or "Accounting" and you
can specify how many decimals you want to display.
REMEMBER if you enter 10.555 but display only 2 decimals, Excel will show
10.56 but the actual value of the cell will be 10.555. (can cause confusion
when adding a column of numbers.
Hope this helps
F
Frank Stone
hi,
goto Tools>options>edit tab.
make sure the fixed decimal box is checked. set places to
2. this will apply to all workbooks.
Regards
Frank
goto Tools>options>edit tab.
make sure the fixed decimal box is checked. set places to
2. this will apply to all workbooks.
Regards
Frank
G
Gord Dibben
Frank
This is not the correct usage of fixed decimals.
That would return 5.64 which OP does not want.
Gord Dibben Excel MVP
This is not the correct usage of fixed decimals.
That would return 5.64 which OP does not want.
Gord Dibben Excel MVP