Number format in Excel

[voskouee]

I am creating Excel worksheets from my tables using VBA. My tables have numbers with the correct format. Single. standart, 2 decimals.

on the sheets created i get just number with 2 decimals. how can i keep the correct formatting?

thanks in advance...

 

[voskouee]

I found it guys... thanks anyway...

this is the way..

Columns("P:Q").Select
Selection.NumberFormat = "#,##0.00"