0 at the begining 00078, how to see it?

**rlneutral** · 02-18-2010, 09:27 AM

I have office 2007.

Have number in a cell like 00078 , when I click on it in a formula I see only number 78, but I whant to see 00078 .

How do you do that?

**zbor** · 02-18-2010, 09:31 AM

Right click -> Format cell as 00000

**rlneutral** · 02-18-2010, 09:40 AM

Right click -> Format cell as 00000

Does not work.

Attached file.

**DonkeyOte** · 02-18-2010, 09:44 AM

If you want the 0's to appear in the formula bar you will need to store the values as Text Strings not Numeric values.

If on the other hand you want to work with the Numeric values as though they had been entered as literal 5 char strings then:

B2: =LEFT(TEXT(A2;"00000"))

would return 0 not 3.

**rlneutral** · 02-18-2010, 09:48 AM

Can someone attach my file where I can see 0003 in a formula window with zeroes. I Tried, but =LEFT(TEXT(A2;"00000") is no taccepted by excel. Seems I a missed somehere. I put that in a B2 cell.

I whant to return 00003 into 00003 in formula window cell.

**martindwilson** · 02-18-2010, 11:02 AM

then use text as DO said ,numbers don't have leading 0
format cell as text then enter your number
then the question arises why do you want to see it like that in formula bar? what are you trying to do?