Hi,


I have one problem in Excel what formula i should apply to remove
Zero's from a number

i.e. i want to remove 000 from

0004317575303272489
0004317575015221980
0004006661030893619

I want the above data as

4317575303272489
4317575015221980
4006661030893619
So Please Tell the solution As soon as possible....

Thanks


--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=523514