LEFT worksheet function

[sw]

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?

 

[JulieD]

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

 

[Govind]

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.