Or right click cell, click format, change to number format.
Odd that it's making it 20.5 when you're typing in 2050
Changing to text format will give you an annoying red mark in corner and ask if u want to convert to a number.
If text does the job though that's cool. I work on Excel evey day and things like that bug you after a while lol
Posted By: CityForLife on February 23rd 2011 at 18:47:09
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.