Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Eliminating digits
I am trying to print a list of customer numbers and they are in a six digit
format. I only want the last four digits printed. The first two numbers are just "00" How do I elimiate those first two numbers? Is it a certain type of formatting? |
#2
|
|||
|
|||
Try this...........enter 1 in an unused cell, then click on it and do Copy
then highlight the cells you wish to change and do PasteSpecial Multiply......... OR, in the next column enter =RIGHT(A1,4) to leave the result formatted as TEXT or =RIGHT(A1,4)*1 to change it to numbers.......... Vaya con Dios, Chuck, CABGx3 "SeanM" wrote in message ... I am trying to print a list of customer numbers and they are in a six digit format. I only want the last four digits printed. The first two numbers are just "00" How do I elimiate those first two numbers? Is it a certain type of formatting? |
#3
|
|||
|
|||
If you try to eliminate the initial 00's with the Replace function, you
could mess up a number like 1200, which this would change to 12. Instead, I would change the number format. In Format-Cells, select the Number tab and click on Custom. In the box to the right type ###0 and this will change an entry like 002345 to 2345. "SeanM" wrote in message ... I am trying to print a list of customer numbers and they are in a six digit format. I only want the last four digits printed. The first two numbers are just "00" How do I elimiate those first two numbers? Is it a certain type of formatting? |
#4
|
|||
|
|||
If they are not Formatted as Custom 000000 then they are probably text.
In that case, follow Chuck's method of changing them to real numbers. Gord Dibben Excel MVP On Tue, 5 Jul 2005 12:19:05 -0700, "SeanM" wrote: I am trying to print a list of customer numbers and they are in a six digit format. I only want the last four digits printed. The first two numbers are just "00" How do I elimiate those first two numbers? Is it a certain type of formatting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mod 10 & 11 | Excel Worksheet Functions | |||
Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
Using a IF formula, I would like to drop the 2 digits in front of. | Excel Discussion (Misc queries) |