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
|