more on adding trailing zero

S

Sammy

Original message below
But is there a way to add the "0" to the A1 cell w/o
getting a circler ref error?
I would have to create another column to use
=IF(LEFT(A1)="0","0"&A1,A1)
Click to expand...

thank you
 
F

Frank Kabel

Hi
first: please stay in the original thread :)
Second: Not possible to have the formula AND the value in
the same cell.

I you don't want to use a helper column you'll need VBA
 
Top