CSV files don't have formatting. They are comma-separated text. If you
want specific formatting, I suggest you save the formatting in an Excel
file, & then copy from your CSV file & Paste Special/ Values into the Excel
file

David Biddulph

"grok" wrote in message
...
I am occasionally opening a .csv file read-only as the file gets written
from
some app. When it is open I can format the cells but each time I re-open
the
file the formatting is gone. Is there a way to retain the formatting?

grok