B
BubbaGumpShrimp
Here's a small but quirk in Excel. If you are in an empty, unformatted cell,
and you set it equal to one date minus another date, the cell should not
automatically be reformatted as a date -- it is obviously a number.
For example, suppose you have
A1 1Jan95
A2 5Jan95
(where A1 and A2 are numbers formatted as dates) and then you add
A3 =A1-A2
A3 should be formatted as a number, not a date.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...f-b9ea8d9bb04c&dg=microsoft.public.excel.misc
and you set it equal to one date minus another date, the cell should not
automatically be reformatted as a date -- it is obviously a number.
For example, suppose you have
A1 1Jan95
A2 5Jan95
(where A1 and A2 are numbers formatted as dates) and then you add
A3 =A1-A2
A3 should be formatted as a number, not a date.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...f-b9ea8d9bb04c&dg=microsoft.public.excel.misc