Number formats after breaking links
 

Using Excel 2003, my program massages data in a worksheet in workbook A
(including formatting the numeric data), creates a chart of that data in the
same workbook, and then copies that chart to workbook B. I need workbook B
to be useable without access to workbook A, and so within workbook B, I break
the links which refer to the worksheet of workbook A.

Before the BreakLink is executed, the format of the data table displayed in
the copied chart is correct. After the break, however, that data loses its
format, and I cannot figure out how to reset those formats. Any ideas?

--
Lon Sarnoff