Hi Tony

Your problem is you haven't told Excel what you want so it's telling you
what it thinks you want.

easiest way to sort this out is to select the cell, row, column, range,
whatever, right click your mouse and select format cells.

then in the first tab, number, select custom. overtype what's in the box on
the right with your format. if you put in 01-Apr-2004 and you want it to
read 4/1 then in the box type m/d m for month d for day / as a seperator.
for the hours and minutes mm for minutes ss for seconds hh for hours etc.

hope this helps.

Jason
"Tony Moffat" wrote in message
...
Numbers that I enter appear as 01-Apr when I really want them to be 4/1
(four to one)..

and..

time entered as 01:06:34 I want to convert to
66.34 seconds....

any help for pensioner, Thanks



Tony