ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why 2003 excell does not accept dot as decimal points (https://www.excelbanter.com/excel-discussion-misc-queries/53248-why-2003-excell-does-not-accept-dot-decimal-points.html)

miki

why 2003 excell does not accept dot as decimal points
 
In 2000 ms excell, if i type 200 and dot (.) it becomes 200.00

In 2003 ms excell, if i type 200. it becomes 2 even I fixed decimal places
to 2.
I want to get 200.00 by typing 200 and dot. In 2003 ms excell, I have to
type 20000 and it become 200 without decimal points so I have to increase
decimal points by clicking increase decimal on the memu to get 200.00

Please reply me as soon as possible.

Thank you
Miki

David Biddulph

why 2003 excell does not accept dot as decimal points
 
"miki" wrote in message
...
In 2000 ms excell, if i type 200 and dot (.) it becomes 200.00

In 2003 ms excell, if i type 200. it becomes 2 even I fixed decimal places
to 2.
I want to get 200.00 by typing 200 and dot. In 2003 ms excell, I have to
type 20000 and it become 200 without decimal points so I have to increase
decimal points by clicking increase decimal on the memu to get 200.00


Unset the Fixed Decimal Places.
--
David Biddulph





All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com