Formula returning a text formatted value

[RandDUser]

In Excel, I have the following formula:

=IF(B1 = $C$2, 1, (B1+1))

But I want the formula to be:

=IF(B1 = $C$2, 01, (B1+1))

I want the cell to be 01, instead of 1. If I change the cell to text, then the formula shows as the value, and I have tried using a single quote and double quotes in the formula, but returns an error. I even tried using a concatenate function, but everything returns a value of 1. It seems like an easy fix.

Any suggestions?

Thank you.

 

[SkipVought]

Do you want this value to be TEXT or a NUMBER formatted with 2 digits?

TEXT
[tt]
=IF(B1 = $C$2, "01", (B1+1))
[/tt]
Number

just format the cell "00" menu item Format/Cells/Custom

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[RandDUser]

I knew it was simple, thank you