Forum Discussion
ArchibaldSM
Jul 27, 2023Copper Contributor
Help with excel formula Please
Hi All, Your assistance would be greatly appreciated as my brain has now melted trying to figure out what the problem could be. I have an Excel spreadsheet with multiple sheets. All of the sheets a...
Patrick2788
Jul 27, 2023Silver Contributor
Cell Formatting in Excel is mere window dressing.
For example:
What matters here is does Excel view the values as texts or numbers. ISTEXT and ISNUMBER can be used to determine this.
ArchibaldSM
Jul 27, 2023Copper Contributor
I resolved the issue - the company laptop was set to US Date in the control panel, changed this to UK and all is now working perfectly.
Many thanks for your assistance 🙂
Many thanks for your assistance 🙂
- SergeiBaklanJul 27, 2023Diamond Contributor
Okay, thank you for the feedback.