Thread: Can I have Excel Show the last 8 digits of a Number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Can I have Excel Show the last 8 digits of a Number?
=RIGHT(A1,8)

"Greg" wrote:

I have a column with 14 digits in each row of the column. Is it possible to
only show the last 8 digits of the number for each row? If show I can I do
this?
Reply With QuoteReply With Quote