Thread: Formatting cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formatting cell

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