| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why are numbers stored as text in my TOAD created Excel output?
I am saving my TOAD query results in Excel spreadsheet format. However, when
I open the Excel file, all the numberic values are being stored as text. Is there a setting in Excel I need to change or is this originating from TOAD itself? Thanks =D |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why are numbers stored as text in my TOAD created Excel output?
hi
more than likely TOAD is doing it. It is not that uncommon for imported data to end up as text. some computer system sore numbers as text. I would investigate your sorce problem from that end. by default excel, ids numbers as numbers and text as text. what to do. enter a one in a cell off the the side. copy it. then high light your numbers as text and paste special - multiply. this should convert the numbers as text to numbers. Regards FSt1 "VK" wrote: I am saving my TOAD query results in Excel spreadsheet format. However, when I open the Excel file, all the numberic values are being stored as text. Is there a setting in Excel I need to change or is this originating from TOAD itself? Thanks =D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| Numbers stored as text | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
