ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I convert numeric data to string format (without VBA)? (https://www.excelbanter.com/excel-worksheet-functions/78565-how-do-i-convert-numeric-data-string-format-without-vba.html)

LissaC

How do I convert numeric data to string format (without VBA)?
 
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!

Richard Buttrey

How do I convert numeric data to string format (without VBA)?
 
On Mon, 20 Mar 2006 11:04:44 -0800, LissaC
wrote:

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!


=TEXT(A1,0)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com