View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sergio sergio is offline
external usenet poster
 
Posts: 10
Default Changin cell format and view

Hi,
I usually get part numbers from other people in the format:
006-1002126 or
008-0073140.
I would like to change it to:
0061002126 and
0080073140
I have tried formatting to custom number 0000000000 but the dashes won't get
removed and the text does not change to number.
Thanks
Sergio