Formating a column in excel

Ammarhm

Beginner User
Local time
Yesterday, 21:48
Joined
Jul 3, 2008
Messages
80
Hi Guys
I have a Questions please
In my DB, One of the buttons exports a query result to an excel file using the follwong command line:
DoCmd.OutputTo acReport, stDocName, acFormatXLS, , True
my problem is that one of the fields exported is a 12 numerical digit... When exported to excel the cells look something like this:
1,92222E+11
instead of 192222222222

´SO the resut becomes a column in exported Excel file with this format for all the exported records
How do i solve this please??

I Appreciate all your help guys
 

Users who are viewing this thread

Back
Top Bottom