Make change to one line

c.Value = "'" & re.Replace(c.Text, "")

That adds an apostrophe to each cell.


Gord


On Fri, 1 Feb 2008 15:29:17 -0800, Abbey Normal
wrote:

I just saw your other post regarding the personal.xls worksheet, and that
works just fine for me. Now the only other question i have is can is there a
way I can have a macro auto'lly change the format of a column to text so this
macro wont change it to sci notation? Thanks a whole bunch!

"Gord Dibben" wrote:

See the post you tacked onto.

http://tinyurl.com/2xcj73

Is that what you are referring to?


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:59:01 -0800, Abbey Normal
wrote:

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.