Date Format and Formula Convention Question

[DCSwearingen]

I have two questions on conventions that are merely curiosity.

First: In the system date formats, many of the date formats will be preceded by

Please Login or Register  to view this content.

Some will use

Please Login or Register  to view this content.

and I am just wondering what these actually do.

The second question has to do with formulas. I have noticed that when I get spreadsheets from other people (predominantly accounting types) that even simple formulas frequently have the plus sign before a cell reference.

Please Login or Register  to view this content.

I have wondered what the purpose of the plus sign would be as the formula works without it.

[VBA Noob]

This might answer the + question

http://www.excelforum.com/showthread.php?t=594467

VBA Noob

[DCSwearingen]

I didn't realize the same question had been posed just a couple of days back.