Excel formats thru VBA

[grasupt]

I have an worksheet where many of the cells have "formatted using the "custom" property. When I print those cells to a file they lose their formatting.
Any idea's?

This is the print line:

Print #FileNum, Trim(Cells(RowCount, _
ColumnCount).Value);

 

[grasupt]

Skip that,

The answer is Format(element,"format&quot, where format is the exact format. Format(99.99,"$00.00&quot

 

[TheRealDeal]

I kinda/maybe/might have a similiar issue. I want the format of the Excel/Cells to be the same as the table that I export to Excel. The table has the proper formats that I want, for example; some columns might have Doubles w/1 decimal where another will have Double w/2 decimals. Again, the table is SHOWING the right format, but Excel does not keep the ideal format. If it helps, I export via a Macro execution.