Thread: How do I remove the apostrophe(') in front of zeros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Learning VBA Learning VBA is offline
external usenet poster
  
Posts: 23
Default How do I remove the apostrophe(') in front of zeros
First custom format with 00000000
Then find and replace
Find '0
Replace with 0


"Tommy" wrote in message
...
I have alot of data that has an apostrophe in front of the numbers with
leading zeros.

How can i remove the apostrophe and keep the zeros in front.

For example:

'00012345 -- 00012345
'00123456 -- 00123456


Reply With QuoteReply With Quote