Hi

When 498 is entered, the first suggestion displays 00498. Or when the format
is "000000", then 000498
When 49800 (or 049800) is entered with format "000000", 049800 is returned

OP mentioned that he is entering 049800, but sees 4980 !!!
I didn't notice the difference in trailing 0's, my mistake of-course. I see
2 explanations for it only:
1) a typo from OP in message;
2) Fixed Decimals in Tools.Options.Edit is set to 1


Arvi Laanemets


"Myrna Larson" wrote in message
...
He mentioned adding a 0 at the end. If he is typing ing 498, the first
suggestion would display 49800 rather than 04980.

A format that would work is 0000\0

On Mon, 10 Jan 2005 14:16:04 +0200, "Arvi Laanemets"
wrote:

Hi

a) format the cell as Custom "00000"
b) format the cell as Text
c) preceede the number with apostrophe, i.e. enter '04980