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
|
|||
|
|||
Trim leading zeros
How do I trim leading zeros from a cells?
000000023 000000003 000000010 Thanks! |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |