View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
marziano marziano is offline
external usenet poster
 
Posts: 1
Default adding zero th alpha numeric value

hello
i have an mp3 catalogue.column F indicates the location of every piece
and the velues in it are in the alpha numeric form of mp3 - xxx. i now
need to switch to thousands instead of hundreds. is there a formula
that can do this (convert mp3 - 234 to mp3 - 0234)?
thanks