How to convert MSExcel 2000 Custom Format 00000000 to TEXT
Posted on 2005-05-05
my true case numbers entered into Excel are as follows:
The same case numbers are DISPLAYED in Excel as 8-digit numbers
(using Excel custom format 00000000) as follows:
That is what I REALLY want... I want 8-digits.
Now... I wish to convert the DISPLAYED numbers into TEXT just EXACTLY as they are... In other words, I want to move the 8-digit numbers into the database, so that ALL the case numbers are 8 digits. So far, every time I attempt a conversion, the numbers come across in their original (NOT as 8-digits). They need to be 8-digit numbers in the database.