Excel Formatting

[CLarkou]

My program sends data from MSAccess to Excel. Numbers are formatted
from Access as percentages with one decimal point.
ex. in MSAccess number is 8.5% but when send to Excel number becomes
8.50%.

Is there any reason for this ? Can it be avoided ? Is time consuming
to format them again in Excel.

 

[Patrick Molloy]

I suspect that you're seeing default formatting. Just add
a k=line to your Access VBA to set the excel format the
way that you want it.

Patrick Molloy
Microsoft Excel MVP

 

[Christina Larkou]

Yes, as soon as I send numbers with DDE commands the cell format becomes
percentage with 2 decimal places, while value has 1 decimal point.

What do you mean add k=line ?