Thread: Text to Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FJinSA
 
Posts: n/a
Default Text to Number

Hi all,
I need help converting data from text to number in order to export into
Access. The current format is as follows:
1234-0000012345-6 and need to have it as 12340000123456
I looked into other postings but could not find a solution...then again I
might have missed it...
Thanks for the help.