Convert Last 3 digits to zero

  • Thread starter Thread starter create_share
  • Start date Start date
C

create_share

Hi!

I need excel to convert the last three digits of a number to zeroes. For
example:

224577 the 577 should automatically be converted to zeroes. Can anybody help?

Thanks!
 
I'm going to answer this in three parts - the first two are separate, then
combined in the last part.

Assuming you have 224577 as the value in the A2 cell, you could put this
formula into B2: =INT(A2/1000)

That would give the value 224 in the B2 cell.

In order to append the three zeros, you could put this formula into the C2
cell: =PRODUCT(B2,1000)

That would put the value 224,000 into the C2 cell.

If you embed one formula into the other, you could put this formula into the
D2 cell: =PRODUCT(INT(A2/1000),1000)

This would put the value 224,000 into the D2 cell.

You want to take the target number, divide it by 1,000, then integerize the
result and multiply your intermediate result by 1,000.

I don't understand why you posted this question on the Outlook board.

Good luck with your spreadsheet.
 
Back
Top