Hi Mike.........
For my XL97, this results in Scientific Notation if the value has 12
significant digits.

Vaya con Dios,
Chuck, CABGx3



"Mike H" wrote:

Put a 1 in any cell and copy it
Select your column of text (numbers) and then
Edit|Paste special
Select multiply and click OK

Mike

"Lori" wrote:

I have data being brought into Excel from another program. I need to convert
a column of data to a number format and eliminate the leading zeros, leaving
only 12 significant digits.