Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How i can remove 000 from 0004317575303272489
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove element from menu | Excel Discussion (Misc queries) | |||
Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |