# Excel Get number at place value Example

This tutorials shows how to get the number at a specific place value in Excel.

To get the number at a specific place value you can use a formula based on the MOD function. By place value, we mean hundred thousands, ten thousands, thousands, hundreds, tens, ones, etc.

## Formula

=MOD(number,place*10) - MOD(number,place)

## Explanation

In the example shown, the formula in cell D8 is:

=MOD(B8,C8*10) - MOD(B8,C8)

The place is thousands (1000), and the result is 3000.

## How this formula works

The MOD function performs the modulo operation. It takes a number and a divisor and returns the remainder after division.

In this formula, we subtract one MOD result from another.

For the first MOD, we use the number with a divisor that equals the place value we want times 10. For the second MOD, we use the number with a divisor equals to the place value we seek. The formula is solved like this:

=MOD(B8,C8*10)-MOD(B8,C8) =MOD(123456,1000*10)-MOD(123456,1000) =3456-456 =3000