Steve,

Simply rename your CSV file as a TXT file, and in the dialog that opens when
you try to open the TXT file, set your column C to be text and Excel will
ignore the .0000 issue.

HTH,
Bernie
MS Excel MVP


"Steve K" wrote in message
...
A need for a macro that is beyond my ability....This macro is to be used in
a
csv file.

In Column "C" I have Part numbers that are formated as 00000000 or
50004590...these do not cause me any issues...and should be left alone.

But in Column "C" I can also have part numbers that are formated as
000.0000
or 440.4300. Excel insists on removing any trailing 0's when opening and
saving a CSV file...whenever it sees a decimal point in Part Number.

I'd like a macro that scans column "C" and when it finds a Part number
that
equals a 000.0000 format it will convert it to text and add any missing
trailing 0's (up to four).

My plan is to save as CSV but not re-open in Excel or save, which (of
course) would again strip training 0's.

Thanks in advance....Steve