Solved open off ice how to have $40 show up as $40.00.enter drops00

November 10, 2014 at 20:27:46
Specs: Windows Vista
In open ofice Calc I want my $40 to show up as $40.00 and when i ENTER IT reverts back to $40.

I am assuming this is a decimal point setting that I am not familiar with.


See More: open off ice how to have $40 show up as $40.00.enter drops00

Report •

#1
November 10, 2014 at 23:40:42
✔ Best Answer
With currencies, it should default automatically to 2 decimal places, but if it isn't then you can change it by right-clicking the cell(s), choose 'format cells', select 'currency' on the left and under 'options', on the right make sure the 'decimal places' is set at '2'.

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd


Report •
Related Solutions


Ask Question