Check how date is entered
On 5/4/2018 8:42 PM, GS wrote:
....
Ambiguities arise when *numeric representation* displays as opposed to
*textual representation* displaying. Auric's code determines whether the
1st element represents d or m. Isn't this what the OP wants to figure out?
....
Yeah, but it depends on what point it is in the process; is it the
format of the cell that determines or the data string going into the
cell? I was presuming it was the latter in which case how the cell is
formatted is the answer to a question as to how Excel interpreted the
string but doesn't _necessarily_ mean that was what the date was from
whence it came.
--
|