a couple of weeks ago I had an issue that when I go to run a jet report that it would not run correctly. For instance I have a cell with the excell formula +now() and the cell would return 1/0/00 instead of the correct date. Most of the other cells started just returning 0's. I have tried multiple different reports which I have been able to run in the past and I get the same type of results.
I do not get any error messages either.
Does anyone have any ideas?
I use jet reports via a remote desktop location where Navision is ran from using Office 2003
My laptop operates using Vista and Office 2007
Date
Votes
1 comment
-
Jet Reports Historic Posts In xl2003 menus:
Tools|Options|Transition tab
Uncheck all those Lotus 123 options–especially "transition formula entry"
With that option checked, excel interprets your entry using Lotus 123 rules and
sees 11/9/2008 as =11/9/2008 (or 11 divided by 9 divided by 2008).
This is a small number that represents a time on that January 0, 1900 date.
Now() can/will do the same thing
Please sign in to leave a comment.