A solution I remember reading on here a while back.
in a seperate cell put a 1
Copy that cell
then Select the column of 'text-numbers'
Paste Special...
Choose Multiply

Steve

On Thu, 05 Oct 2006 08:44:02 +0100, Avadivelan TCS
wrote:

Does anyone know how to escape(remove)single quote to
appear before a values, when a report is exported from
Access to Excel. I tried to use "replace", "clean"
or "right" functions but it does not help.
I am having more than 3600 columns like that:
€˜394,3568,789
'7896,456,1234
Can you suggest a macro for this

Thanks in advance for your reply




--
Steve (3)