Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to get number
Hello,
I have the following Serial No check Digit 40212463794 4 40212463802 2 40212463810 0 40212463828 8 40212463836 6 40212463844 4 40212463851 1 The last number is a check digit and the check digit is arrived by =Number-10*INT(Number/10) The Number is including the check digit. Now I want to get the number without check digit and check digit in another column so if I input the serial numbers like: 4021246379 4021246380 4021246381 4021246382 4021246383 4021246384 4021246385 then how can i get the check digit? Is there an easy formula? Thanks Abdul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to automatically change one number to another number | Excel Discussion (Misc queries) | |||
formula to throw out high number and low number | Excel Worksheet Functions | |||
Creating number formula to count number occurences in a data set | Excel Programming | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) |