ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   last digit (https://www.excelbanter.com/excel-programming/322961-re-last-digit.html)

Myrna Larson

last digit
 
Assuming the number is an integer, =MOD(A1,10)


On Thu, 10 Feb 2005 21:57:03 -0800, choice
wrote:

how would i go about getting the last digit in a number. for example 5326 it
will return 6, 42 will return 2.
i think theres an equation for this too but im not sure
thanks in advance




All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com