Home |
Search |
Today's Posts |
#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 <atyahoo<dotcom ---- "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |