Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I have Excel Show the last 8 digits of a Number?
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I have Excel Show the last 8 digits of a Number?
You would need to use another column with a formula.
It all depends on what you need the 8 digits for. A1 = 12345678901234 =RIGHT(A1,8) That will return the result as a *TEXT* value. =--RIGHT(A1,8) That will return the result as a *numeric number*. However, Excel doesn't like numbers that have leading zeros so it drops any leading zeros. A1 = 12345600001234 =--RIGHT(A1,8) returns the numeric number 1234 What you can do is format the cell as Custom using this format: 00000000 Then the result will be 00001234 However(!!!), the leading zeros are for display purposes only. Excel still doesn't recognize those leading zeros. This can be important if you need to perform further calculations on the "numbers". -- Biff Microsoft Excel MVP "Greg" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I have Excel Show the last 8 digits of a Number?
One other option is simply to use Data / Text To Columns / Fixed width to
chop the data into 2 parts. You can choose the "Do Not import" option on the section of numbers you don't want. Regards Ken................... "Greg" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I have Excel Show the last 8 digits of a Number?
Ken, thanks, I took the easy way out and took your suggestion. I don't know
why I did not think to do this. I made an easy thing hard. Thanks again. "Ken Wright" wrote: One other option is simply to use Data / Text To Columns / Fixed width to chop the data into 2 parts. You can choose the "Do Not import" option on the section of numbers you don't want. Regards Ken................... "Greg" wrote in message ... 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? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I have Excel Show the last 8 digits of a Number?
The only thing you have to be careful about is that if the first number of
any of your remaining numbers is a 0, then you will end up with 7 digit or less number. Regards Ken..................... "Greg" wrote in message ... Ken, thanks, I took the easy way out and took your suggestion. I don't know why I did not think to do this. I made an easy thing hard. Thanks again. "Ken Wright" wrote: One other option is simply to use Data / Text To Columns / Fixed width to chop the data into 2 parts. You can choose the "Do Not import" option on the section of numbers you don't want. Regards Ken................... "Greg" wrote in message ... 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? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I have Excel Show the last 8 digits of a Number?
Unless of course you specify that the output is text.
"Ken Wright" wrote in message ... The only thing you have to be careful about is that if the first number of any of your remaining numbers is a 0, then you will end up with 7 digit or less number. Regards Ken..................... "Greg" wrote in message ... Ken, thanks, I took the easy way out and took your suggestion. I don't know why I did not think to do this. I made an easy thing hard. Thanks again. "Ken Wright" wrote: One other option is simply to use Data / Text To Columns / Fixed width to chop the data into 2 parts. You can choose the "Do Not import" option on the section of numbers you don't want. Regards Ken................... "Greg" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get excel to check last 2 digits in a 4 digit number | Excel Discussion (Misc queries) | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
can i multiply digits of a number by a constant in excel? | Excel Discussion (Misc queries) | |||
Combo Box - Show only first two digits? | Excel Discussion (Misc queries) | |||
how do i show only the last four digits of a credit card number | Excel Discussion (Misc queries) |