Full Version: transferspreadsheet
UtterAccess Forums > Microsoft® Access > Access Forms
mmb
I have table with an integer value (nEntries) and a currency value (nValue) that i export to excel via TransferSpreadsheet method.
Is there anyway to format them so that when opened in excell they will appear as formatted;
nEntries nValue
9,982 7,987.80
currently all i get is
nEntries nValue
9982 7987.8
, or is automation my only answer to do this?
thanks
dashiellx2000
Format your values in a query using the Format function. Then transfer the query rather then the table.
TH.
mmb
Ok thanks, will try that.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.