moderated Re: Excel and jaws;
toggle quoted messageShow quoted text
Another quick way is to copy a date from another date formatted cell and then change the date to the date you want.
From: email@example.com <firstname.lastname@example.org> On Behalf Of Chris Chaffin
Sent: Monday, August 26, 2019 1:18 PM
Subject: Re: Excel and jaws;
I am not sure what you are exactly trying to do. You said that Excel is not recognizing dates as text only.
Excel recognizes the contents of a cell depending on how you have the cell formatted. How do you have the cells you are entering dates in formatted? To change the format of a cell hit control and the number 1 on the numbers row. This will bring up the format dialog box. I would recommend changing the format of the cells to date to see if this helps you accomplish what you are trying to do.