View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Go to ToolsOptionsEdit and see if the Fixed decimal box is checked. If so,
uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"shiv" wrote in message
...
Although the cells have been formatted for numbers, entries are displayed

as
one hundredth of the keyed in number.
How do I get the displayed number to be exactly as keyed in?