| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign a format for value?
Does anyone have any suggestions on how to assign a format for specific value?
for example There is a date in cell A1 and there is a value in cell B1, I would like to display A1 & B1 into cell C1, for example 15-Jun [Cell A1] 4 [Cell B1] 15-Jun [4] in Cell C1 Does anyone have any suggestions? Thank in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to assign a format for value?
One way:
C1: =IF(COUNTA(A1:B1)=2,TEXT(A1,"dd-mmm")&TEXT(B1," \[0\]"),"") In article , Eric wrote: Does anyone have any suggestions on how to assign a format for specific value? for example There is a date in cell A1 and there is a value in cell B1, I would like to display A1 & B1 into cell C1, for example 15-Jun [Cell A1] 4 [Cell B1] 15-Jun [4] in Cell C1 Does anyone have any suggestions? Thank in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I assign a shortcut key (alt letter) to the format painter | Excel Discussion (Misc queries) | |||
| How Do I Assign a Toolbar Button to a Custom Number Format I creat | Excel Discussion (Misc queries) | |||
| Assign Macro to tab | Excel Discussion (Misc queries) | |||
| assign | Excel Discussion (Misc queries) | |||
| Assign a number to a name | Excel Worksheet Functions | |||
Linear Mode
