Aug 06 2021 02:15 AM
I have similar sheet with date in one cell.
When I used sheet function IsNumber (Je.Číslo in Czech language version) on this date cell, result is true.
When I used the same function in VBA (Application.WorksheetFunction.IsNumber) on this date cell, result is false.
Why? Thank you for help.
Libor Krkoska
Aug 06 2021 05:03 AM
I cannot reproduce the problem in the English language version of Excel.
Which date did you use?
Could you attach a workbook demonstrating the problem?
Aug 06 2021 09:13 PM
Aug 06 2021 11:11 PM
SolutionAug 07 2021 12:17 AM
Aug 06 2021 11:11 PM
Solution