| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering data
I cannot enter the data the way I want. For example, I want to enter the
number 280000 and it will enter 2800.00. I have tried putting the number in as General, but I still get the fixed decimal. I have tried to enter it as a number with 0 decimal places, but I still get the fixed decimal or it will round off. What do I need to do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering data
On Jun 4, 1:29 pm, booklady
wrote: I cannot enter the data the way I want. For example, I want to enter the number 280000 and it will enter 2800.00. I have tried putting the number in as General, but I still get the fixed decimal. I have tried to enter it as a number with 0 decimal places, but I still get the fixed decimal or it will round off. What do I need to do? Go Tools|Options then go to the Edit tab of the Options dialog and deselect the Fixed decimal places option Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Data | Excel Discussion (Misc queries) | |||
| Entering data | Excel Worksheet Functions | |||
| Entering Data: is there a way to do this? | Excel Discussion (Misc queries) | |||
| Entering Data | Excel Discussion (Misc queries) | |||
| Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
Linear Mode
