bwesenberg
New Member
- Joined
- Sep 7, 2004
- Messages
- 31
I get unexpected results when date formatting a worksheet cell in a MS Excel spreadsheet - in other words it looks like a calculation is trying to take place such that entering 1220 in the cell returns a date of 5/4/1903 and entering 12202006 0r 122006 returns a negative date displayed as ########. I have not experienced something like that before – and I use MS Excel way too much!
The cells are formatted as dates.
Is there a way I can enter the dates with out the slashes?
The cells are formatted as dates.
Is there a way I can enter the dates with out the slashes?