more on adding trailing zero

  • Thread starter Thread starter Sammy
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Trailing 30 days sum calculation with excel 1
Equal "" when zero has a space after it 6
How do I make this work? 15
Scrabble Value calculation for Welsh words 0
Automatically adding cells with values 3
Calculating STDEV for non zeroes 1
Yet another copy/paste macro question 6

Back
Top