Hi Tim
try
=INT(cell_reference)
and format as date

--
Regards
Frank Kabel
Frankfurt, Germany

Tim wrote:
If a cell says 2.8 for instance and i format that cell to be a date
with format 03/04/97and it comes out showing in the cell 01/03/00 but
the formula and value actually are 01/03/1900 12:05 . How do i make
it so the time is not there( 12:05)

Tried paste special value. did not work