Prev: "File Error: Data May Be Lost" when file saved on Mac is opened in Windows
Next: How to cc the sender using vba and outlook
From: Mike on 29 Dec 2009 14:27
So, I just upgrade my OS to Windows 7. I have a spreadsheet that does time
calculations from time to hours. It has worked flawlessly for years, and
even for the first day I had Windows 7... in the same spreadsheet. Now it
doesn't seem to recognize the 12:00 AM format and it's being interpreted as
text, not time anymore. When I reformat the cell so that it's a new time
format, it's not interpreting any of them anymore....

Is anybody else having this problem? Have you heard/seen this before?
From: Mike on 29 Dec 2009 14:42
Okay, I figured it out... apparently you can't change your OS date time
settings/format without it effecting excels calculations. I had changed it
so the date on my task bar would show the day of the week too... so when I
changed the global format for date/time it came through right again.

"Mike" wrote:

> So, I just upgrade my OS to Windows 7. I have a spreadsheet that does time
> calculations from time to hours. It has worked flawlessly for years, and
> even for the first day I had Windows 7... in the same spreadsheet. Now it
> doesn't seem to recognize the 12:00 AM format and it's being interpreted as
> text, not time anymore. When I reformat the cell so that it's a new time
> format, it's not interpreting any of them anymore....
>
> Is anybody else having this problem? Have you heard/seen this before?
From: Bernard Liengme on 29 Dec 2009 14:43
I doubt this has anything to do with Win 7 - just a coincidence.
Us Clear All on the cell and reenter 12:00 AM
IF this is cell A1, in another cell enter =A1+2/24 to see if you get 2:00 AM
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Mike" <Mike(a)discussions.microsoft.com> wrote in message
news:A6B7A057-CC4D-4E0B-B859-0E52BAECFCBD(a)microsoft.com...
> So, I just upgrade my OS to Windows 7. I have a spreadsheet that does
> time
> calculations from time to hours. It has worked flawlessly for years, and
> even for the first day I had Windows 7... in the same spreadsheet. Now it
> doesn't seem to recognize the 12:00 AM format and it's being interpreted
> as
> text, not time anymore. When I reformat the cell so that it's a new time
> format, it's not interpreting any of them anymore....
>
> Is anybody else having this problem? Have you heard/seen this before?

 | 
Pages: 1
Prev: "File Error: Data May Be Lost" when file saved on Mac is opened in Windows
Next: How to cc the sender using vba and outlook