View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clegge
 
Posts: n/a
Default 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