Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SeanM
 
Posts: n/a
Default 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   Report Post  
CLR
 
Posts: n/a
Default

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   Report Post  
Richard Neville
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mod 10 & 11 Pablo Excel Worksheet Functions 13 August 10th 05 11:39 AM
Concatenate function - keeping "displayed" extra digits EricKei Excel Discussion (Misc queries) 3 June 15th 05 10:16 PM
Least number of digits in Y-axis labels Charley Kyd Charts and Charting in Excel 9 February 6th 05 04:03 PM
How do I format cells to a specific number of digits? Gabriele Excel Discussion (Misc queries) 3 February 5th 05 04:17 PM
Using a IF formula, I would like to drop the 2 digits in front of. osuhoosier Excel Discussion (Misc queries) 2 January 6th 05 09:21 PM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"