Will I be able to perform this function and leave the data in the same
column, or will I need to perform this function in another column?

"CLR" wrote:

If you are not going to be doing math with the "numbers", then maybe this
would do you.....

=RIGHT(A1,12)

Vaya con Dios,
Chuck, CABGx3

"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.