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