View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default typed numbers entered in cell wrong

Try this:

From the Excel main menu:
<tools<options<edit tab
Uncheck: Fixed decimal places

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Fred J" wrote:

I typea number in a cell and it appears divided by 10 i.e type 90 enter amd
.9 appears in cell