Thread Options Tools
#1879851 - 12/18/13 05:01 PM Excel Question
Princess of Power Offline
Gold Star
Princess of Power
Joined: Aug 2002
Posts: 406
Napa, CA
Admit that I am stumpped and not sure if or how to do the following. Is there a way to take a 16 (or any size) digit number and have ONLY the last 4 digits appear?

Thank You

Return to Top
General Discussion
#1879871 - 12/18/13 05:18 PM Re: Excel Question Princess of Power
Doug Hendrickson Offline
Power Poster
Doug Hendrickson
Joined: Oct 2009
Posts: 3,927
If all you want is the last four digits, you could use a formula such as =RIGHT(A1,4) which would only place the last four digits into the cell in which you have the formula, as shown below.

1234567890123450 3450
_________________________
I hear and I forget. I see and I remember. I do and I understand.--Confucius

Return to Top
#1879885 - 12/18/13 05:35 PM Re: Excel Question Princess of Power
Princess of Power Offline
Gold Star
Princess of Power
Joined: Aug 2002
Posts: 406
Napa, CA
Thank You - You made my day!!

Return to Top
#1880100 - 12/18/13 10:01 PM Re: Excel Question Princess of Power
basilring Offline
Gold Star
Joined: Mar 2012
Posts: 298
Spartan Country!
I like that tip too. Awesome!
_________________________
Everyone should believe in something. I believe I will head for the beach!

Return to Top