| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove leading zero from a string..
just getting back into excel formulas... this is probally an easy question.... i basically have a collumn full of account numbers that represent numeric strings.... if the first position of the string is a zero, i would like to pull it out... so 01147548 would become 1147548 -- thanks! -- clegge ------------------------------------------------------------------------ clegge's Profile: http://www.excelforum.com/member.php...o&userid=29927 View this thread: http://www.excelforum.com/showthread...hreadid=496235 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove leading apostrophes in Excel? | Excel Discussion (Misc queries) | |||
| Remove leading space | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
Threaded Mode
