# Convert Last 3 digits to zero

• Views 829
Status
Not open for further replies.
Y

#### Y3JlYXRlX3NoYXJl

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!

V

#### VGhpcGRhcg

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.

"create_share" wrote:

> 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!

#### Brian Tillman

Senior Member
"create_share" <createshare> wrote in message
news:0943D5B7-B983-4755-AC46-FF8098629C18@microsoft.com...

> I need excel to convert the last three digits of a number to zeroes.

Why ask an Excel question in an Outlook newsgroup?

Status
Not open for further replies.