| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get excel to check last 2 digits in a 4 digit number
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get excel to check last 2 digits in a 4 digit number
=MOD(A1,100)?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate a check-digit in Excel? | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to replace 12 digits only of 16 digit number. | Excel Discussion (Misc queries) | |||
| Why is Excel changing the last 2 digits of a 17 digit num to 00. | Excel Discussion (Misc queries) | |||
Hybrid Mode
