Thread: format a column from E605EQ1212 to E 605 EQ 1212
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott at Scott Scott at Scott is offline
external usenet poster
  
Posts: 1
Default format a column from E605EQ1212 to E 605 EQ 1212
Please Help, I've done every thing the online help provided. Like below in
the Custom block

\A 000 \A\A 0000
E 000 "EE" 0000
"E" 000 "EE" 0000

I need it to auto format to look like this E 605 EQ 1212

Thank You for your time.
Reply With QuoteReply With Quote