Hi Ville,
Use the 'text' function to format the time cell using the some format
specifier that you used to format the cell:
="At "&TEXT(A1;"HHMM")&" "&B1
tc
Ville Mattila wrote:
Hello,
I am trying to create a spreadsheet that contains some formatted
information in cells (for example special time format HHMM and so on). I
would like to create a concatenated string from the formatted values of
the cells and some static texts.
Example
A B C
1 0920 My Event = CONCATENATE("At "; A1; " "; B1)
The result on C1 is like "At 373918,2331441 My Event" even I would like
it to be "At 0920 My Event".
How this should be done?
Thanks,
Ville
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
