View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default formatted numbers to CSV problem

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.