| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link loses formatting
I have two cells, the first is suppose to be four characters and the second
is suppose to be six. These two cells are combined into a third cell. Sometimes people don't enter the full six digits so I changed the cell formatting so that it pre-fills zeros when people forget. However when these are copied over to the new cell the pre-filled zeros are lost. The formula in the third cell is ... =IF(B10="","",$B$2&B10) If B2 is 1234 and B10 is 000123 I would like the new cell to be 1234000123 but it only shows 1234123 and loses the pre-filled zeros. Does any of this make sense? Does anyone have any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link loses formatting
=IF(B10="","",$B$2&text(B10,"000000"))
Do you need =text() around the B2, too? FrankM wrote: I have two cells, the first is suppose to be four characters and the second is suppose to be six. These two cells are combined into a third cell. Sometimes people don't enter the full six digits so I changed the cell formatting so that it pre-fills zeros when people forget. However when these are copied over to the new cell the pre-filled zeros are lost. The formula in the third cell is ... =IF(B10="","",$B$2&B10) If B2 is 1234 and B10 is 000123 I would like the new cell to be 1234000123 but it only shows 1234123 and loses the pre-filled zeros. Does any of this make sense? Does anyone have any ideas? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link loses formatting
THAT'S EXACTLY WHAT I NEEDED !!!!!!!!!
"Dave Peterson" wrote: =IF(B10="","",$B$2&text(B10,"000000")) Do you need =text() around the B2, too? FrankM wrote: I have two cells, the first is suppose to be four characters and the second is suppose to be six. These two cells are combined into a third cell. Sometimes people don't enter the full six digits so I changed the cell formatting so that it pre-fills zeros when people forget. However when these are copied over to the new cell the pre-filled zeros are lost. The formula in the third cell is ... =IF(B10="","",$B$2&B10) If B2 is 1234 and B10 is 000123 I would like the new cell to be 1234000123 but it only shows 1234123 and loses the pre-filled zeros. Does any of this make sense? Does anyone have any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying tab loses formatting | Excel Worksheet Functions | |||
| copy/paste loses formatting | Excel Discussion (Misc queries) | |||
| Dynamic Picture defined by Name using a formula loses link when sa | Excel Worksheet Functions | |||
| Macro that loses formatting | Excel Programming | |||
| Excel workspace loses formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
