Nobody on Earth seems to be able to answer my question, so I turn my eyes to the stars ... Does anyone on this board know how to switch off Microsoft Excel's overeagerness in changing random numbers into dates and currency? I can't enter a simple 7-2 without it changing to "2 Jul"...and switching the cells to General changes it to something like 32956.
Posted by TSN (Member # 31) on May 05, 2007 02:53 AM:
Did you try changing it to "Text"?
Posted by Ventriloquists Got Shot (Member # 239) on May 05, 2007 03:18 AM:
Also, if you put a single apostrophe before the entry, it will register as test. Or maybe it is a quotemarkthing. Either way.
EXAMPLE:
'July 7
Posted by The Ginger Beacon (Member # 1585) on May 05, 2007 05:19 AM:
Or in Dans case '7-2
Posted by Nim (Member # 205) on May 05, 2007 07:12 AM:
North of Huế. I've seen some badass spellcheckers before but nothing like this.
Posted by Daniel Butler (Member # 1689) on May 06, 2007 08:04 AM:
Hmmm...didn't occur to me to change it to text. That's like...that's like....God, I feel stupid.
![[Razz]](tongue.gif)
... Does anyone on this board know how to switch off Microsoft Excel's overeagerness in changing random numbers into dates and currency? I can't enter a simple 7-2 without it changing to "2 Jul"...and switching the cells to General changes it to something like 32956.