Thread: How do I remove the apostrophe(') in front of zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tommy Tommy is offline
external usenet poster
  
Posts: 70
Default How do I remove the apostrophe(') in front of zeros
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