|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 12th, 2004, 03:11 PM
|
|||
|
|||
Trim leading zeros
How do I trim leading zeros from a cells?
000000023 000000003 000000010 Thanks! 
|
|
#2
August 12th, 2004, 03:20 PM
|
|||
|
|||
|
Trim leading zeros
Hi
one way: - format the cells with a number format - select an empty cell and copy this cell - select your range of data - goto 'Edit - Paste Special' and choose 'Add' -----Original Message----- How do I trim leading zeros from a cells? 000000023 000000003 000000010 Thanks! .
|
|
#3
August 12th, 2004, 03:28 PM
|
|||
|
|||
|
Trim leading zeros
If your data is in column A and if you only have integers,
type in cell B1: =TEXT(VALUE(A1),"0") and copy this down (if you need text, if you need values, omit the text function). Regards, sulprobil
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I show leading zeros in a number field | tfinklea | Database Design | 1 | August 11th, 2004 07:30 PM |
| Linked Table field...strip off leading zeros of text | Inyo55 | Database Design | 1 | July 24th, 2004 01:11 AM |
| Check for lost leading zeros | Bonnie | General Discussion | 4 | June 15th, 2004 08:00 PM |
| Number with leading zeros | SteveM | Worksheet Functions | 3 | February 2nd, 2004 04:47 PM |
| Leading Zero's | Tami | Worksheet Functions | 2 | November 24th, 2003 03:27 PM |
Linear Mode
