LEFT worksheet function

I have the following formula;

=(ROUND(A1,3-LEN(INT(A1)))) e.g. 123,456 would change to
123,000

I also want to be able to return only the 1st 3 numbers of
this e.g. changes to 123. I have tried adding in Left
(A1,3) but everywhere I place this in the formula it does
not seem to work e.g. I tried =ROUND(LEFT(A1,3),A1,3-LEN
(INT(A1))))

Any ideas?

Hi sw

how about
=LEFT(ROUND(A1,3-LEN(INT(A1))),3)

or

=LEFT(ROUND(A1,-3),3) 'depending on the other numbers you are rounding

Cheers
JulieD

"sw" wrote in message
...
I have the following formula;

=(ROUND(A1,3-LEN(INT(A1)))) e.g. 123,456 would change to
123,000

I also want to be able to return only the 1st 3 numbers of
this e.g. changes to 123. I have tried adding in Left
(A1,3) but everywhere I place this in the formula it does
not seem to work e.g. I tried =ROUND(LEFT(A1,3),A1,3-LEN
(INT(A1))))

Any ideas?

Hi,

You can try

=ROUND(A1,3-LEN(INT(A1)))/10^(LEN(INT(A1))-LEN(RIGHT(INT(A1),3)))

Tho there can be better solutions.

Regards

Govind.

sw wrote:

I have the following formula;

=(ROUND(A1,3-LEN(INT(A1)))) e.g. 123,456 would change to
123,000

I also want to be able to return only the 1st 3 numbers of
this e.g. changes to 123. I have tried adding in Left
(A1,3) but everywhere I place this in the formula it does
not seem to work e.g. I tried =ROUND(LEFT(A1,3),A1,3-LEN
(INT(A1))))

Any ideas?