![]() |
|
#6
|
|||
|
|||
|
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) |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Auto update excel graph range, ignore data when date reads 00-Month-00
|
SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
Filter by a Month that falls within a date range
|
MattG1225 | Excel | 2 | 12-03-2015 07:44 AM |
Formulato say if cell is blank do this, if not blank do this.
|
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
| calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |