Hi I have a file (large file) that I import from Datewarehouse server. We have used " to keep the leading zeros as it its getting truncated when improting to excel file from the server. Now when file is opened I see ' for all the numbers even though they do not have leading zeros as it converted the numbers to text. I need to copy the data to some other files and upload to another audit tool. My challange is that I want to remove the apostphe for all the data but keep leading zeros for the ones that have. Is there any formula or any way to do it. Attaching sample file with two tab first one with data that is currently seen and the second one as desired output. I really thank and appreciate any help.