When typing in a Telephony Patch reference for example 4/16, Excel is throwing up an Error Mark "This cell contains a date string represented with only 2 digits for the year"
How do I format the cell to stop throwing up these error marks, I'm sure its really simple and is just a cosmetic issue really.
As always many thanks for your help.
Small example attached below.
I opened your file and found no issues. I reformatted the first date cell as a date with the format of mm/dd and entered the date. I see that your dates are formatted as text. I was unable to recreate your issue.
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks