L

#### Lori

a column of data to a number format and eliminate the leading zeros, leaving

only 12 significant digits.

You should upgrade or use an alternative browser.

L

a column of data to a number format and eliminate the leading zeros, leaving

only 12 significant digits.

C

would do you.....

=RIGHT(A1,12)

Vaya con Dios,

Chuck, CABGx3

M

Select your column of text (numbers) and then

Edit|Paste special

Select multiply and click OK

Mike

S

=--RIGHT(A1,12)

--

Regards,

Sandy

In Perth, the ancient capital of Scotland

and the crowning place of kings

(e-mail address removed)

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

C

For my XL97, this results in Scientific Notation if the value has 12

significant digits.

Vaya con Dios,

Chuck, CABGx3

C

I also get Scientific Notation with this formula in my XL97...........

Vaya con Dios,

Chuck, CABGx3

P

Hi Sandy & Chuck,

Try it with:

00123456789123456

Pete

Try it with:

00123456789123456

Pete

L

column, or will I need to perform this function in another column?

D

If the input is a number, rather than text, then by default it would lose

the leading zeroes.

If there is a decimal point within the 12 significant digits, then you may

want =LEFT(A1,13) or =--LEFT(A1,13) to get it back to being a number (but

this will truncate, rather than rounding).

More generally, one can probably get to 12 significant figures with

=ROUND(A1,11-INT(LOG10(A1)))

S

In point of fact I had not been following the thread and I was just

responding to your post so I had not noticed the 12 significant digits.

Maybe I should mind my own business <g>

--

Reagrds,

Sandy

In Perth, the ancient capital of Scotland

and the crowning place of kings

(e-mail address removed)

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

C

Mine still returns the 12 rightmost digits.......since the OP asked for 12

significant digits from a string with leading zeros, I assumed there would

not be more.........probably dumb of me tho.....<g>

Vaya con Dios,

Chuck, CABGx3

S

So surely there are only 12 numeric characters?

--

Regards,

Sandy

In Perth, the ancient capital of Scotland

and the crowning place of kings

(e-mail address removed)

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

Hi Sandy & Chuck,

Try it with:

00123456789123456

Pete

L

without having the results end up in another column. I have 2 fairly complex

macros using this column and I need to keep it in the same location. I know

I can add in several steps to cut and paste the results back into this column

location but I was trying to avoid that.

C

want to only stay within the same column, try the Data > TextToColumns

feature........

Vaya con Dios,

Chuck, CABGx3

C

Vaya con Dios,

Chuck, CABGx3

R

General format will take a 12 digit number and automatically convert it to

scientific, even on the XL02 machine I'm on today.

Just format to Number, either before or after the Paste Special.

C

and try again.

Vaya con Dios,

Chuck, CABGx3

C

have to try it again at work on monday...........

Vaya con Dios,

Chuck, CABGx3

P

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