If your importing data, I assume your using Automation. So just have another step to format the cells after you populate them.
PF
>Hello,
>
> I have an existing Excel spreadsheet that I need to import some data into. The cells that I am populating have the currency format. When I populate the cells, the format becomes numeric. Is there a way to avoid this without converting the data to the format of the cell?
(On an infant's shirt): Already smarter than Bush