Thread: Decimal Places
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Decimal Places

Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Sundara Murthy" wrote in message
...
Hello Experts,

I am entrying the numberic value 55555 result will be displaying like

555.55
how to avoid this?

Any setting will be changed?

regards,
Sundara Murthy.S