| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I have Excel determine what the last digit is in a series?
Hi all,
I am trying to have excel determine what the last digit is in a 9 digit series of numbers to apply basic encryption to said series of 9 digit numbers. Is there a way that Excel can recognize whether the last digit is a 1 or 2, etc... Thanks for any help you can give me. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I have Excel determine what the last digit is in a series?
=--RIGHT(A1,1)
-- Gary''s Student - gsnu200842 "BinaryOrc" wrote: Hi all, I am trying to have excel determine what the last digit is in a 9 digit series of numbers to apply basic encryption to said series of 9 digit numbers. Is there a way that Excel can recognize whether the last digit is a 1 or 2, etc... Thanks for any help you can give me. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I have Excel determine what the last digit is in a series?
While there is nothing wrong with Gary's answer, here is alternatives
=MOD(A1,10) will return the last digit of the number in A1 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BinaryOrc" wrote in message ... Hi all, I am trying to have excel determine what the last digit is in a 9 digit series of numbers to apply basic encryption to said series of 9 digit numbers. Is there a way that Excel can recognize whether the last digit is a 1 or 2, etc... Thanks for any help you can give me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In series of 10 digit #s, how can I exclude 1st 3 digits in each? | Excel Worksheet Functions | |||
| NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN | Excel Discussion (Misc queries) | |||
| how to determine if a series of numbers contain odd or even values | Excel Worksheet Functions | |||
| I'm trying to determine how a series of dropdown lists were creat. | Excel Discussion (Misc queries) | |||
| How do I determine statistical relationship between two series | Charts and Charting in Excel | |||
Linear Mode
