Hoopsah
10-02-2008, 07:25 AM
Hi
We currently have an Excel spreadsheet containg various info.
In column E we have a unique identifier in the form of 9 digits, these are still all preceded by zeros i.e. 000324555
What happens is we have to copy the data into another program and unless all of these zeros have been preceded by an apostrephe i.e. '00324555 then it is copied over as 324555 (not correct)
Does anyone know of a basic formula or macro that will allow me to put an apostrophe at the start of each number within that column (I suppoes it should ensure that there isn't already an apostophe there already)
Thanks for your help
We currently have an Excel spreadsheet containg various info.
In column E we have a unique identifier in the form of 9 digits, these are still all preceded by zeros i.e. 000324555
What happens is we have to copy the data into another program and unless all of these zeros have been preceded by an apostrephe i.e. '00324555 then it is copied over as 324555 (not correct)
Does anyone know of a basic formula or macro that will allow me to put an apostrophe at the start of each number within that column (I suppoes it should ensure that there isn't already an apostophe there already)
Thanks for your help