Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
doesn't really say that. For all I know, you typed it in by hand.
point taken. It was a small number of columns with a middle sized number of rows, that my boss and someone else asked me to look at this morning when they ran into the formatting issue. I just strung it together in a text formula, and used a tiny code module to export it. In that instance, copying and pasting to Notepad would have worked about as well. Yep, I noticed the issues you mentioned about opening it in Excel and getting the same reformatting problem... and, I understand and could do what you're suggesting about using the Text import wizard (or coded version) and setting that column to Text. If the people that needed it this morning need it again, I'll do that. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numbers formatted as text | Excel Discussion (Misc queries) | |||
formatted numbers displayed as ##### | New Users to Excel | |||
Sorting formatted numbers | Excel Discussion (Misc queries) | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
importing large numbers to vb results in the numbers being formatted to scientific | Excel Programming |