generally formatting a cell that already contains a value will not change the
way the value is stored.

--
Regards,
Tom Ogilvy


"stevebriz" wrote:


DavidB wrote:
What do you have the cell formatted as?

Currency

Have you tried fromatting the cells after import then summing?