Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

csv file truncating zero values

When I open a csv file and change contents on the first row via excel,
numbers such as 000999 are saved as 999. I need to change column headings
on the first row of my csv file and save it while preserving the number
formatting below it. Can this be accomplished using the Write or Print
statement via vba? At present, I am opening it and saving it with Excel.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Truncating a VIN	lputnam	Excel Discussion (Misc queries)	3	November 11th 09 05:28 PM
csv file truncating zero values	Patrick Molloy[_2_]	Excel Programming	0	April 17th 09 05:38 PM
Truncating values of each sale in the range	fbagirov	Excel Programming	1	July 13th 07 09:52 PM
Exported File truncating cell data after 255 characters	Sue Rizzo	Excel Discussion (Misc queries)	2	March 17th 05 08:47 PM
Copy values from file A, Find/Replace these values in File B	shockley	Excel Programming	1	September 22nd 03 12:32 AM

All times are GMT +1. The time now is 08:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us