Access 2010 query
Linked excel worksheet
The field/column in question is a field formatted in EXCEL as number and looks like this 24.9406175771971
I have an append query currently that is taking the number and turning it into : 2494.06%
The field I'm appending to is a text field(by someone elses design)
After importing the data i need the number to look like "Percent" 2 decimals 24.94
I have tried:
but it will not work?