moderated Re: Excel and jaws;
Jschliff@...
Another quick way is to copy a date from another date formatted cell and then change the date to the date you want.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin
Sent: Monday, August 26, 2019 1:18 PM To: main@jfw.groups.io 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.
Chris
|
|