Hi to all!!

im working on a workbook at my company to extract some data from software and analyze.
In one of the columns i have to get a date, which is in text format, and transform into date format to calculate.
I used VALUE() function, and it worked like a charm, so i finished and and sent the workbook to person who in fact is gonna do the analysis.
The problem is that in his computer the VALUE function is not working, is returning error #value.
So i tried other ways like DATEVALUE, add 0, multiply by 1, double negation, nothing works.

We have the exact same excel version, i checked everything that a could think of, but nothing works.

Has anyone here seem this problem before?