| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thanks you all!
"Anne Troy" wrote: Try something like this, Carlos, assuming your 16-digit number is in column C: ="A"&right(C2,1) That'll add the letter A to the last character in C2 ************ Anne Troy www.OfficeArticles.com "Carlos" wrote in message ... In excel I need to take the last digit of a 16 digit number from one column and then write it down into another column with a letter in front of it |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| How do I change the number on copy sheet so I don't have to renam | Excel Worksheet Functions | |||
| Entering a 16 digit number | Excel Discussion (Misc queries) | |||
| Accidentally converted date mm/dd/yy to a 5 digit number | Excel Worksheet Functions | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Threaded Mode
