Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
Excell VS Office | Excel Discussion (Misc queries) | |||
Decimal Points | Excel Worksheet Functions | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
Why can't we see or access MS Excell 2003 even though we have MS . | Setting up and Configuration of Excel |