Posted to microsoft.public.excel.misc

Dave O

external usenet poster

Posts: 427

Formulas and Dates not working in compatibility mode

The integer values you see are Excel's way of handling dates. Before
pursuing a formula solution, did you try formatting the integer "date"
cells to a date format?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compatibility mode HELP please	Nat	Excel Discussion (Misc queries)	1	April 16th 09 08:28 AM
what is compatibility mode and how do you get it off	[email protected]	Excel Discussion (Misc queries)	1	March 11th 08 04:18 PM
Compatibility mode	shane	Excel Discussion (Misc queries)	3	December 6th 07 08:38 PM
compatibility mode	Jus[_2_]	Excel Discussion (Misc queries)	2	September 2nd 07 01:28 PM
Compatibility Mode	Jerry	New Users to Excel	7	May 22nd 07 08:34 PM

All times are GMT +1. The time now is 02:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us