Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check the last digit of each cells vaue in the column
Hi all,
Could anyone know how to use Macro to check the last digit (1 to 9) of the cell value? e.g. Cell A1 = 21, 22 ........, 29 then it will be multiply by 10 Cell A2 = 201, 202, ........., 209 then it will be multiply by 10 Thanks Tlee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a vaue | New Users to Excel | |||
How can you format cells in a column to display a 50 digit binary | Excel Discussion (Misc queries) | |||
Can Formulas use a certain Digit, like the 1st or 2nd Digit, in all Cells in a Range? | Excel Programming | |||
Mod-10 Check Digit | Excel Worksheet Functions | |||
Mod-10 Check Digit | Excel Worksheet Functions |