Numeric/character numbers

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

I have an Excel spreadsheet which has field containing phone numbers.

When I open the spreadsheet it tells me that some of the rows contain
numbers stored as chharacters and asks me if to convert them.

I don't want to - in fact I want to convert them all to character. This is
because I need to import them into SQL and if some are numeric I get bad
values.

How can I convert them to character values?

I also have a field with $ values in it. It treats them as Money dtata type
where I would like it to be treated as a character type.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
To convert column A to text, in row one of a new colum put the fomula
=A1&""
and copy it down. If you wish, you can then copy this new column and
Edit|Paste Special|Values back into column A.

Jerry
 
Back
Top