LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
numbers formatted as text willemeulen[_28_] Excel Discussion (Misc queries) 13 June 8th 09 02:25 PM
formatted numbers displayed as ##### NinaGrewalOff New Users to Excel 9 September 19th 05 01:48 PM
Sorting formatted numbers Hunter Excel Discussion (Misc queries) 2 August 31st 05 01:09 AM
Converting numbers formatted as text to numbers Bill Excel Discussion (Misc queries) 1 July 19th 05 07:10 PM
importing large numbers to vb results in the numbers being formatted to scientific molly Excel Programming 2 February 3rd 04 02:27 PM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"