| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem entering amounts
I seem to have done something to Excel which now means that everytime I enter
a number such as say 100 it comes out in the cell as 1 If I enter 20 it comes out as 0.2 I have the format set to 2 decimal places as usual and I never used to have a problem. I have obviously changed something in the set up as it happens on all my documents but not if I send them through to my hubby's computer!! I have tried uninstalling Office 2003 and then reinstalling but the same problem occurs so I guess there is some data being saved in my User Account. Help please ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem entering amounts
From the menu, Tools Options Edit, then uncheck the "Fixed decimal
places" box. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Sky" wrote in message ... I seem to have done something to Excel which now means that everytime I enter a number such as say 100 it comes out in the cell as 1 If I enter 20 it comes out as 0.2 I have the format set to 2 decimal places as usual and I never used to have a problem. I have obviously changed something in the set up as it happens on all my documents but not if I send them through to my hubby's computer!! I have tried uninstalling Office 2003 and then reinstalling but the same problem occurs so I guess there is some data being saved in my User Account. Help please ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing from Excel Sheet Problem | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Linear Mode
