MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing preceeding zero's in excel

Posted by Peta Revell on April 18, 2001 3:17 AM


can anyone tell me how to remove preceeding zero's in excel I thought I could do this with a value function but I keep getting an error message has anyone any ideas

Posted by Dave Hawley on April 18, 2001 3:30 AM

Hi Peta

I just tried this:
=VALUE(A1) (A1 Had 00001254801 in it!)
on A1 formatted as Text and it returned:

What does the error say?


OzGrid Business Applications

Posted by keekee on April 19, 2001 5:38 AM

how about multiplying the cell by one? (=a1*1) It usually works for me. If I need to keep it as text, I use: =clean(a1*1)