Try typing an apostrophe before the number....it won't show up, it just sets
the cell to TEXT format.........or, pre-format the cell for TEXT.

Vaya con Dios,
Chuck, CABGx3


"breeze" wrote in message
...
The real number I enter into cells need be "049800".
I got "4980". How to adjust that display zero in front and behind number?