| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change format for displaying data in cell?
I'm currently using Excel in Office 2000. A recent change occured and I
cannot change it. When entering a number in a cell, it automatically displays it as a decimal. For example, if I type "25" it is displayed in the cell as 0.0025 as soon as I hit enter. If I type "25.0" then it displays as 25. I have changed cell formats before, but I did not do this change. Please help!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change format for displaying data in cell?
ToolsOptionsEdit tab, uncheck Fixed decimal
-- Kind regards, Niek Otten Microsoft MVP - Excel "mango" wrote in message ... | I'm currently using Excel in Office 2000. A recent change occured and I | cannot change it. When entering a number in a cell, it automatically | displays it as a decimal. For example, if I type "25" it is displayed in the | cell as 0.0025 as soon as I hit enter. If I type "25.0" then it displays as | 25. I have changed cell formats before, but I did not do this change. | Please help!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change format for displaying data in cell?
Thanks, GREATLY appreciated, have a good one...
"Niek Otten" wrote: ToolsOptionsEdit tab, uncheck Fixed decimal -- Kind regards, Niek Otten Microsoft MVP - Excel "mango" wrote in message ... | I'm currently using Excel in Office 2000. A recent change occured and I | cannot change it. When entering a number in a cell, it automatically | displays it as a decimal. For example, if I type "25" it is displayed in the | cell as 0.0025 as soon as I hit enter. If I type "25.0" then it displays as | 25. I have changed cell formats before, but I did not do this change. | Please help!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change format for displaying data in cell?
mango
ToolsOptionsEdit. Uncheck "Fixed Decimal Places" Gord Dibben MS Excel MVP On Thu, 3 Aug 2006 14:36:02 -0700, mango wrote: I'm currently using Excel in Office 2000. A recent change occured and I cannot change it. When entering a number in a cell, it automatically displays it as a decimal. For example, if I type "25" it is displayed in the cell as 0.0025 as soon as I hit enter. If I type "25.0" then it displays as 25. I have changed cell formats before, but I did not do this change. Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In EXCEL 2002 format cell with existing data. | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Remove Data Format Change | Excel Discussion (Misc queries) | |||
| monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
Linear Mode
