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