Patrice Calve

# re: Disable Date "Autocorrect" in MS Excel 2003

It's a pain... I've been searching for something similar - entering fractions and numbers with dashes - and it appears that if the autocorrect dialog in the Tools menu doesn't have the option to switch it off (apparently present in some versions, but not in mine), then you're limited to typing prefixes.

For fractions, you can use a 0 in front (so 0 1/7 will end up with a 1/7 in the box); for any number that you don't want converted (as in your case) put a single quote before you type it in; so e.g. enter '4.2.1 in the box.

It's a pain, but at least it's a start.
Hope that helps!

# re: Disable Date "Autocorrect" in MS Excel 2003

Oops, forgot to say that the quote is a special call to Excel and doesn't actually appear in the box!

# re: Disable Date "Autocorrect" in MS Excel 2003

just click on extras / options / international / number handling /
uncheck "use system separators", change
decimal separators to "." (without quotation marks) and the Thousands separator to " " for example. After importing the data, just replace all "." to "," so that also other excel user get the right contents displayed. And you can switch back using system separators.

# re: Disable Date "Autocorrect" in MS Excel 2003

In Office 2000, format the cells as Text under the "Format Cells" option

# re: Disable Date "Autocorrect" in MS Excel 2003

"In Office 2000, format the cells as Text under the "Format Cells" option"

This doesn't work if you've pasted the cells in.

# re: Disable Date "Autocorrect" in MS Excel 2003

"just click on extras / options / international / number handling / "

There is no "extras" menu option in Excel 2003

# re: Disable Date "Autocorrect" in MS Excel 2003

It's under tools, not "extras." But this still doesn't seem to fix that problem.