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, Feb 23, 18:12:49
Follow Ups
- Easy. Press alt+F4 to sort it out. Answer "no" when it asks you questions.
Posted By: Old Man, Feb 23, 19:22:22 - Is it every cell?
Posted By: Rusty Steele, Feb 23, 18:53:05 - 1Or right click cell, click format, change to number format.
Posted By: CityForLife, Feb 23, 18:47:09 - 1Trying to work out why it would do this??
Posted By: Rusty Steele, Feb 23, 18:30:58 - You can also add an apostrophe, like so - '2050
Posted By: tim berry, Feb 23, 18:17:29 - 1Right click, format cell, change to text
Posted By: Swanny, Feb 23, 18:14:52
Reply to Message
Written & Designed By Ben Graves 1999-2025