Anybody around who is good with microsoft excel?
I have a problem. When i input a value (2050) into a cell it changes it to 20.5. Is there anyway i can stop this from happening?
thanks in advance!
J
Posted By: Al NCFC4life on February 23rd 2011 at 18:12:49
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.