Excel output from Access VBA
Posted on 2014-12-19
I am creating a spread sheet from Access using VBA. I have a serial field that should be displayed as text all the time but am having a problem with it. The serial number field contains alpha and numeric data. When the serial number happens to be a large number (eg: 5305588100043) it displays on the spreadsheet as 5.30559E+12. Within the VBA code to create the spreadsheet, I have the serial number cell set to objXLS.Cells(1, 8).NumberFormat = "@".
Is there any other way to force this cell to always display full text regardless of what data is in that field?
Thanks for your help