Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Leading 0s and Col Formatting
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Leading 0s and Col Formatting
A couple of possible solutions... As a formula
=text(A1, "00000000") which will convert the number to text and ensure that there are 8 digit which would include leading zeros Format Cell - Custom - 00000000 Which will change how the number is displayed. It is still stored as a number without leading zeros, but it is displayed with the leading zeros. HTH "Brent E" wrote: 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Leading 0s and Col Formatting
Use a custom number format of 000000.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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 | |||
Leading Zero | Excel Discussion (Misc queries) | |||
keeping leading 0's when formatting cells | Excel Discussion (Misc queries) | |||
Formatting numbers with leading and trailing zero's | Excel Worksheet Functions | |||
leading zero | Excel Discussion (Misc queries) | |||
How do I retain leading zero zip code formatting when saving as a. | Excel Discussion (Misc queries) |