View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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