View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jhahes[_38_] jhahes[_38_] is offline
external usenet poster
 
Posts: 1
Default converting text to numbers


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