I wrote code to stack 6 files containing similar data and save to CSV format.
One column of data contains DateTime format, loaded by Showcase in the
format: yyyymmddhhmmss, where the range of one day spans from 20060430000000
to 20060430235959. Everything works fine until the file is saved to CSV
format. All DateTime data is converted to Scientific format while all other
data in the transfer maintains General Formatting. All DateTime data displays
yyyymm followed by eight zeros (the day and time are all converted to zeros).
Therefore, 20060430154523 is converted to 20060400000000 and is formatted
Scientific.

This program runs using OnTime at a specific time each day. What code can I
use to preserve the General Format, rather than it changing to Scientific?
I've tried to enter code to convert each item to NumberFormat=0, but it still
converts to Scientific upon saving to CSV.

Thanks

When I use number format, 0 decimal places the CSV looks fine.

--
Jim
"Sam" wrote in message
...
|I wrote code to stack 6 files containing similar data and save to CSV
format.
| One column of data contains DateTime format, loaded by Showcase in the
| format: yyyymmddhhmmss, where the range of one day spans from
20060430000000
| to 20060430235959. Everything works fine until the file is saved to CSV
| format. All DateTime data is converted to Scientific format while all
other
| data in the transfer maintains General Formatting. All DateTime data
displays
| yyyymm followed by eight zeros (the day and time are all converted to
zeros).
| Therefore, 20060430154523 is converted to 20060400000000 and is formatted
| Scientific.
|
| This program runs using OnTime at a specific time each day. What code can
I
| use to preserve the General Format, rather than it changing to Scientific?
| I've tried to enter code to convert each item to NumberFormat=0, but it
still
| converts to Scientific upon saving to CSV.
|
| Thanks