| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format to show leading zero
Use custom format: 000000
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "lehigh46" wrote in message ... Hi All: Column A has 6 digit equipment numbers, some with leading zero's. (The cells are formatted to show leading zero's) Column B has 3 digit month names. In column C I want to concatinate A & B ie; 0400051 FEB 0400051FEB When I type in the formula =A5&B5 the leading zero is gone. How can I keep it desplayed? Thanks for your help. Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show leading zeros. | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Is it possible to show leading zeros for "number" cells? | Excel Discussion (Misc queries) | |||
| How to show a leading 0 in a cell. | Excel Discussion (Misc queries) | |||
![Bernard Liengme[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
