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 :
Did you try changing it to "Text"?
Posted by Ventriloquists Got Shot (Member # 239) on :
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 :
Or in Dans case '7-2
Posted by Nim (Member # 205) on :
North of Huế. I've seen some badass spellcheckers before but nothing like this.
Posted by Daniel Butler (Member # 1689) on :
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.