1. main@jfw.groups.io

moderated Re: Strange Excel Issue Regarding Date formatting

Mario
 

Tom, I'm no expert using Excel, but when you're on the cell, if you press control+1 and then press tab, what is the formatting set to? is it different from cells that don't muck with the date as you want it displayed?


when that happens to me, the first thing to check is the formatting.

-------- Original Message --------
From: Tom Behler [mailto:tombehler@gmail.com]
To: jfw list <jfw@groups.io>
Date: Wednesday, July 8, 2020, 7:46 PM
Subject: Strange Excel Issue Regarding Date formatting
Hello, everyone.

I am working on an Excel spreadsheet report for an organization, and
have encountered a very strange problem.

Typically, when I enter a date into the first column of a given row, I
put 7/08/2020 as an example.  Jaws reads this correctly, and life is good.

However, this evening, for some reason, when I enter 7/08/2020, the
column entry reads 8Jul.

I have no idea why this is happening, or what I might have done to
change the date formatting.

Any help to get things back to normal here would be appreciated.

Thanks!

Tom Behler
Join main@jfw.groups.io to automatically receive all group messages.
More
Home Messages Hashtags Subgroups About Features Pricing Updates Terms Help Twitter