View Single Post
  #1   Report Post  
Phil
 
Posts: n/a
Default Place a "" around ALL values in a cell

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.