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

Hi

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:
1254801

What does the error say?

Dave

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)