k, IT returned a date as the answer, but with the dashes around it. I also
wanted to know how to change between two conventional date formats quickly
without using the mouse, cos i use two different formats yeah.
ThanKs!
Peo Sjoblom wrote:
It may look like dates but it isn't dates in excel sense, you can make any
calculations, as an example
put 101499 in A1, it will display as 10/14/1999, now in A2 put 101699,
displays as 10/16/1999
now if these were dates that one could make calculations with
=A2-A1
formatted as General would return 2 (for 2 days), in your case it returns
200?
so you can use them as display a number that looks like a date but you can't
do anything with it
if you want to cut down on the usage of delimiters you can use Chip
Pearson's macro
http://www.cpearson.com/excel/DateTimeEntry.htm
Hello Group,
[quoted text clipped - 7 lines]
What's up with that!??
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1