How do I format the cell such that a 0 appears at the left of number I imput?
example: If I enter 098 after hitting the enter key it will only show 98 on
the cell.

Thank you for your assistance

joseph robert

Format as TEXT or place an apostraphe " ' " first when inputting the data.
The apostraphe will not show on your sheet but will in the formula bar.

Mike Rogers

"joseph robert" wrote:

How do I format the cell such that a 0 appears at the left of number I imput?
example: If I enter 098 after hitting the enter key it will only show 98 on
the cell.

Thank you for your assistance

If you want to input 098 and keep it that way, then either format the cell
as text before you put the number in, or prefix it with an apostrophe: '098
--
David Biddulph

"joseph robert" wrote in message
...
How do I format the cell such that a 0 appears at the left of number I
imput?
example: If I enter 098 after hitting the enter key it will only show 98
on
the cell.

Thank you for your assistance

You may also set "0"#.# as format. Do do this select the cell, hit ctrl-1,
Number, Category=Custom, Type="0"#.#

This will be ok for your example. If you try to enter other types of numbers
like more than 1 million, then it needs to be adapted.

--
Stefano Gatto


"joseph robert" wrote:

How do I format the cell such that a 0 appears at the left of number I imput?
example: If I enter 098 after hitting the enter key it will only show 98 on
the cell.

Thank you for your assistance