The point was that with 00123456789123456 stripped of leading zeros
and to 12 significant digits you want to end up with:

123456789123000

but I see that the thread has rumbled on after I posted ...

Pete

On Jan 11, 7:48*pm, "Sandy Mann" wrote:
I am afraid that I don't follow your point. *The OP said,

a column of data to a number format and eliminate the leading zeros,
leaving
only 12 significant digits

So surely there are only 12 numeric characters?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

...
Hi Sandy & Chuck,

Try it with:

00123456789123456

Pete

On Jan 11, 7:24 pm, "Sandy Mann" wrote:



Or if you do want it to be a number:

=--RIGHT(A1,12)

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"CLR" wrote in message

...

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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -