Tools/ Options/ Edit/ Unset Fixed decimal places
--
David Biddulph

"pm hudson" wrote in message
...
For example....when I key 109 into a cell, it returns 0.00109. All
numbers
are converted in this way. It adds 0.00 to each number entered. Even
when
changing the formatting, it still returns the same number.

"Rick Rothstein (MVP - VB)" wrote:

When I key numbers into a cell, the format returned is not
what is keyed in....and no matter what format I change it
too, it stays the same. HELP!!

It would really help if you told us what numbers you were keying in, what
"format" you were seeing for it and what "format" you were expecting to
see.
Otherwise, we cannot know what your problem is.

Rick