Excel Formatting

  • Thread starter Thread starter CLarkou
  • Start date Start date
C

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.
 
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
 
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 ?
 
Back
Top