Formatting

[Prixton]

Hi,
In a column I want all the numbers to end with 000. The figures are coming
from other files and are sometimes with one, two or three 0:s
How can I format the cells so that the numbers always come with 000 in the
end?
Thanks in advance

 

[IC]

Prixton, it's not clear what you mean here.

If you mean you want to round the number to the nearest 1000 eg 12345 to
appear a 12000 then assuming your number is in A1, in B1 enter

=INT(A1/1000)*1000

If what you mean is that you want 3 decimal places in each case (eg 12.345)
then format the cell as Number and select 3 decimal places.

Ian

 

[Prixton]

No what I want is that all figures shall end with 000 that is 125000, 126000
and so on.
Is this possible?

 

[IC]

It's not possible in the same cell, as far as I know, but if you have a
column next to your data, use the formula I sent below. This will round all
cells so that the last 3 digits are zero. Another way is to use
=ROUND(A1,-3), though it still needs another cell.

Ian