How do I convert numeric data to string format (without VBA)?

L

LissaC

Hi, I'm wondering if anyone out there knows how I can convert a column of
numeric values into a 'string' format? I'm not too familiar with VBA so if
there's a function that would do the trick I'd be grateful for any help! I'm
trying to make the data compatible with string data in order to join tables
in ESRI ArcView.

Many thanks!
 
R

Richard Buttrey

Hi, I'm wondering if anyone out there knows how I can convert a column of
numeric values into a 'string' format? I'm not too familiar with VBA so if
there's a function that would do the trick I'd be grateful for any help! I'm
trying to make the data compatible with string data in order to join tables
in ESRI ArcView.

Many thanks!
Click to expand...

=TEXT(A1,0)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top