| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONVERTING NUMBERS TO TEXT | Excel Worksheet Functions | |||
| converting numbers to text | New Users to Excel | |||
| Converting numbers to text | Excel Discussion (Misc queries) | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
![jhahes[_38_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
