Is it every cell?
If so, check Tools>Options>Edit tab and uncheck "Fixed Decimal Places"
It appears that there is an option there to save accountants having to input decimal places!
Posted By: Rusty Steele on February 23rd 2011 at 18:53:05
Message Thread
- Anybody around who is good with microsoft excel? (General Chat) - Al NCFC4life, Feb 23, 18:12:49
- Easy. Press alt+F4 to sort it out. Answer "no" when it asks you questions. (General Chat) - Old Man, Feb 23, 19:22:22
- Is it every cell? (General Chat) - Rusty Steele, Feb 23, 18:53:05
- Or right click cell, click format, change to number format. (General Chat) - CityForLife, Feb 23, 18:47:09
- Doesn't ask if you turn error warnings off (n/m) (General Chat) - Swanny, Feb 23, 19:01:56
- Trying to work out why it would do this?? (General Chat) - Rusty Steele, Feb 23, 18:30:58
- its microsoft, who knows? (General Chat) - Al NCFC4life, Feb 23, 18:36:05
- You can also add an apostrophe, like so - '2050 (n/m) (General Chat) - tim berry, Feb 23, 18:17:29
- Right click, format cell, change to text (n/m) (General Chat) - Swanny, Feb 23, 18:14:52
- perfect! cheers! (n/m) (General Chat) - Al NCFC4life, Feb 23, 18:26:25
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.