You sure that doesn't work?

It worked fine for me.

Dave Breitenbach wrote:

The =""""&a1&"""" doesn't work because it recognizes the entire string as
between quotes and results in a1 surrounded by the &, instead of the value in
a1 surrounded by quotes. The following works for me:
="''"&B5&"''"
This may look similar but let me write it in text so you can see how it's
different -shown entered as keystrokes(separated by commas)...

equals,double quote,single quote,single quote,double quote,&,B,5,&,double
quote,single quote,single quote,double quote

So it's putting two single quotation marks which results in a double to fool
excel.

hth,
Dave

"Alan" wrote:

Not really sure about this but you could try, if you're data is in Column
A1:A2000
In B1
=""""&A1&""""
Copy down from B1:B2000 and Copy Paste Special Values to lose the
formulas,
See if it works!
Regards,
Alan.
"Phil" wrote in message
...
Hello,

I have a situation where I have been told the only way to get my data to
work with Access is to take EVERY value (some 2,000) in each cell, and
wrap a
double quote around ANY of the values that reside in the cell.

So the value 54712332 would need to look like "54712332".

How do I go about doing that?

TIA for your replies!

Phil.




--

Dave Peterson