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

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"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?

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?

Thanks a lot.

breeze
=========
"Arvi Laanemets" wrote in message
...
Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"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?

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

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