Concatenate only deals with the values of the cells and not with the formats
applied to those cells. In order to concatenate and apply colour would
require a bunch of code (assuming you want different formats for each cell
being concatenated). Otherwise just format the cell with the concatenate
formula.
--
HTH...

Jim Thomlinson


"Thierry" wrote:

Hello,
With the function concatenate, how can we
A) Ask to get the same format as the original cell
B) Force a color format, like red
Exemple = concatenate(A1; " "; A2; " "; A3)
I would like that
1) A1 displays the same color and number format as the cell A1 (for example
green with number #'##0.00
2) Force the format of A2 in red

I know that the function TEXT exists
=concatenate(TEXT (A1;"#'##0.00"); etc.)
But how can I say "red" or "same format as cell A1" ?
Thank you for all advise