Formatting 11001981003213 as text..
On Thu, 15 Nov 2007 20:03:01 -0800, Bob Barnes
wrote:
is a serial number. I'm an Access Programmer running
automation to Excel. This long serial number, even when formatted as text on
the Auto_Open event, displays as scientific notation.
Is there an Excel setting to ensure it appears as text?
TIA - Bob
Oh, also, if all the serial numbers are less than 16 digits, you could also
just format the cell as number (with zero decimal places). In that case,
though, any leading zero's will be dropped.
--ron
|