formatting

J

joseph robert

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
 
D

David Biddulph

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
 
M

Mike Rogers

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
 
S

Stefano Gatto

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.
 
Top