Quote:
Originally Posted by ellocco
I managed to verify the content via the function: "CELL":
=CELL("format", A1)
Gives an output dependent the cell content.
I expect something like: DD.MM.YYYY hh:mm:ss
and this correspond to the function output: "D1"
A cell format of "hh:mm:ss" gives: "U4"
It might be that the function is sensitive to your localization,
I have tested it with a German localization, the German variant is:
'ZELLE("format";B18) |
FYI this thread is 9 years old...
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|