calculate using last four digits of number in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same.
 
=--right(a1,4)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Barcode Check Digits 3
Validation of UK VAT Number 20
//sk - Max length of a numeric field. 4
"IF" function query 5
What function do I use to calculate a Sum of Digits? 3
Create a function wher last digit is always set 4
How can I have Excel determine what the last digit is in a series? 2

Back
Top