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
|
|||
|
|||
Format Cols
I've got an Excel workbook that contains many license numbers and I need to
format the column so that if a license number has several 0s in front, they aren't automatically truncated by Excel. I tried general, number, and text formats but they truncate leading 0s. Any ideas? Thanks. |
#2
|
|||
|
|||
TEXT formatting should work fine........
Highlight the column, Right-click . FormatCells NumberTab select TEXT OK........then enter your numbers with the leading zeros.....and all the rest of the numbers........they will be all left-justified. If you are copying something to the column, then use "PasteSpecial Values" to prevent the formatting being changed during copying..... Vaya con Dios, Chuck, CABGx3 "Brent E" wrote in message ... I've got an Excel workbook that contains many license numbers and I need to format the column so that if a license number has several 0s in front, they aren't automatically truncated by Excel. I tried general, number, and text formats but they truncate leading 0s. Any ideas? Thanks. |
#3
|
|||
|
|||
And if you want it as numbers but displaying the leading zeros,
try selecting the col, then: Format Cells Custom Enter in the "Type:" box: 000000 (say) Now if you enter: 99, it'll appear as: 000099 999 will appear as: 000999 and so on Adapt to suit (the number of zeros in "Type" box) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- "Brent E" wrote in message ... I've got an Excel workbook that contains many license numbers and I need to format the column so that if a license number has several 0s in front, they aren't automatically truncated by Excel. I tried general, number, and text formats but they truncate leading 0s. Any ideas? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
can't format cell - have tried unlocking and unprotecting | griffin | General Discussion | 1 | April 5th, 2005 02:11 AM |
How to format cells in Excel for time in format mm:ss.00 | Very Timely | Worksheet Functions | 0 | March 30th, 2005 07:35 AM |
why does currency format change to number format? | Cassie | General Discussion | 3 | March 18th, 2005 06:57 PM |
Changing the Date Format | xtian_princess | Worksheet Functions | 1 | September 8th, 2004 02:54 PM |
Any way of forcing Plain Text Format universally? | Astra | General Discussions | 0 | June 4th, 2004 09:34 AM |