Excel auto-correct
-
Hi, I get annoyed when I want to insert some specific 'data' in a cell on a excel sheet. Suppose I want to enter '1 - 10' (exactly this) into a cell, excel automatically replace that with a date format '1/okt'. Grrrr I hate when it does a thing like that :mad:. And there doesn't seem to be an easy way to force the initial text :mad:. Anybody knows how to desactivate this feature ? (I already checked in 'AutoCorrect options' but I couldn't find it)
Cédric Moonen Software developer
Charting control -
Hi, I get annoyed when I want to insert some specific 'data' in a cell on a excel sheet. Suppose I want to enter '1 - 10' (exactly this) into a cell, excel automatically replace that with a date format '1/okt'. Grrrr I hate when it does a thing like that :mad:. And there doesn't seem to be an easy way to force the initial text :mad:. Anybody knows how to desactivate this feature ? (I already checked in 'AutoCorrect options' but I couldn't find it)
Cédric Moonen Software developer
Charting controlYou woudn't have this on a Mac... Mac's are into "fun" stuff, like podcasting. Or editing your family's vacation videos... Or surfing the net... no boring stuff like spreadsheets there... http://movies.apple.com/movies/us/apple/getamac_ads2/work_480x376.mov[^] That being said, you could enter '1 - 10 (including the ') and Excel shouldnt parse that as a date then.
-
Hi, I get annoyed when I want to insert some specific 'data' in a cell on a excel sheet. Suppose I want to enter '1 - 10' (exactly this) into a cell, excel automatically replace that with a date format '1/okt'. Grrrr I hate when it does a thing like that :mad:. And there doesn't seem to be an easy way to force the initial text :mad:. Anybody knows how to desactivate this feature ? (I already checked in 'AutoCorrect options' but I couldn't find it)
Cédric Moonen Software developer
Charting controli am not sure if i understood you correctly, but if you want to display "1-10" in the cell, just prepend a single quote, like this: '1-10
-
You woudn't have this on a Mac... Mac's are into "fun" stuff, like podcasting. Or editing your family's vacation videos... Or surfing the net... no boring stuff like spreadsheets there... http://movies.apple.com/movies/us/apple/getamac_ads2/work_480x376.mov[^] That being said, you could enter '1 - 10 (including the ') and Excel shouldnt parse that as a date then.
-
i am not sure if i understood you correctly, but if you want to display "1-10" in the cell, just prepend a single quote, like this: '1-10
Yes, you understood me correctly ;) Thanks for the tip, I didn't know that (yeah, I know I suck with excel ;P)
Cédric Moonen Software developer
Charting control -
Hi, I get annoyed when I want to insert some specific 'data' in a cell on a excel sheet. Suppose I want to enter '1 - 10' (exactly this) into a cell, excel automatically replace that with a date format '1/okt'. Grrrr I hate when it does a thing like that :mad:. And there doesn't seem to be an easy way to force the initial text :mad:. Anybody knows how to desactivate this feature ? (I already checked in 'AutoCorrect options' but I couldn't find it)
Cédric Moonen Software developer
Charting control -
i am not sure if i understood you correctly, but if you want to display "1-10" in the cell, just prepend a single quote, like this: '1-10
Zdeslav Vojkovic wrote:
...just prepend a single quote, like this: '1-10
I was wondering if someone was going to suggest this. I remember it from 15 years ago when I used to use Lotus 1-2-3. Amazing the tips you pick up, and remember, over the years.
"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank
"Judge not by the eye but by the heart." - Native American Proverb