Forum Discussion
combine text with =today function
I want to combine the text string 'LAST OPENED ' with the =TODAY() function in a single cell. What is the proper syntax? I have tried the following in cell B1 which is formatted as General: 'LAST OP...
; is not more or less correct than , in itself.
It is the list separator specified in your system settings.
Usually, if you use point as decimal separator, then comma is the list separator.
And if comma is your decimal separator, then semicolon is the list separator.