I have a problem. I am importing data into a spreadsheet and i believe
the data being imported is in text format. And I am trying to do a
index match formula with a sheet trying to read off of the imported
data and getting all these #n/a. Can someone please help me. I can
change the column of the imported sheet to number format, but i have to
rekey all the numbers because they are stored as text when imported.


Thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=473520

change the column to number format

Select the column, then do Data=Text to columns

select delimited and then Tab as the delimiter, then finish.

When done, the cells should contain numbers. If not, then you probably have
leading or trailing spaces.

--
Regards,
Tom Ogilvy


"jhahes" wrote in
message ...

I have a problem. I am importing data into a spreadsheet and i believe
the data being imported is in text format. And I am trying to do a
index match formula with a sheet trying to read off of the imported
data and getting all these #n/a. Can someone please help me. I can
change the column of the imported sheet to number format, but i have to
rekey all the numbers because they are stored as text when imported.


Thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=473520

You can try this:

In a blank cell anywhere on your sheet, enter the number 1 (as
number, not text). Copy this cell (Ctrl+c)

Highlight your entire range of text numbers and do a Paste-Special
selecting Multiply in the 'Operation' section. Click OK. Your tex
entries are now numeric.

Does this work for you

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47352