ExcelBanter - How to get excel to check last 2 digits in a 4 digit number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to get excel to check last 2 digits in a 4 digit number (https://www.excelbanter.com/excel-discussion-misc-queries/215296-how-get-excel-check-last-2-digits-4-digit-number.html)

realtorpete

How to get excel to check last 2 digits in a 4 digit number

Pete_UK

How to get excel to check last 2 digits in a 4 digit number

Check them against what?

More details, please, and in future use the white space here to
describe your problem more fully.

Pete

On Jan 4, 7:48*pm, realtorpete
wrote:

Sheeloo[_3_]

How to get excel to check last 2 digits in a 4 digit number

=Right(A1,2) will give you the right two digits (as text) of a four digit
number.

I agree with Pete - Pl. use the text area to describe the problem... respect
those out there who are trying to help...

"Pete_UK" wrote:

Check them against what?

More details, please, and in future use the white space here to
describe your problem more fully.

Pete

On Jan 4, 7:48 pm, realtorpete
wrote:

barry houdini[_4_]

How to get excel to check last 2 digits in a 4 digit number

=MOD(A1,100)?

All times are GMT +1. The time now is 08:16 PM.