Thanks so much for your help... it worked! We are just trying to figure
out why all of a sudden it changed, as we never had problems with
the slashes before and definitely never changed the autocorrect.

Thanks again and Happy New Year!!

Duke and Vicky

"Dave Peterson" wrote:

This is deleting the autocorrect entry (if that is the problem).

If you want a slash, then this won't affect any slash that you type.

And this autocorrect entry (as well as any other autocorrect entry) is shared in
other MSOffice programs (MSWord, Excel, PPT, ...).

Do you want slashes replaced with dots sometimes?

duke and vicky wrote:

won't that always change the slashes to dots, even when we DO want
the slashes. Will that change any previous work saved on other excel files?

"Dave Peterson" wrote:

It kinds of sounds like there's an autocorrection entry that changes dots to
slashes.

In xl2003:
tools|Autocorrect options|Autocorrect tab
look for that dot (.) entry and delete it.



duke and vicky wrote:

We have been trying to format a cell to take numbers with three decimals. As
soon as we type the number after the decimal point, the point shows as a
forward slash. We've tried all methods of formatting to no avail.

IE:

we want 12.056 and it will show 12/056,
or it will come up like .0445 (example)

Thanks for any help

(microsoft office 2003)

--

Dave Peterson


--

Dave Peterson