| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formatting
I have 2 sets of data/columns that I'm formatting to show 7 digits (e.g. 5240
becomes 0005420). I'm concatenating this with another column of 1-3 digits but when I concatenate I'm loosing the leading zeros which I still need (the # becomes 15240 instead of 10005240). Any ideas of how I can get the leading zero's to stay? Thx. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formatting
=text(A1,"0000000") & text(B1,"0000000")
Bob Umlas Excel MVP "Darin" wrote: I have 2 sets of data/columns that I'm formatting to show 7 digits (e.g. 5240 becomes 0005420). I'm concatenating this with another column of 1-3 digits but when I concatenate I'm loosing the leading zeros which I still need (the # becomes 15240 instead of 10005240). Any ideas of how I can get the leading zero's to stay? Thx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Linear Mode
