deleting part of an entry

[chris.howes]

I have a cell that contains DD/MM/YYYY HH:MM:SS
and need to remove the time from the cell have writen a macro but i
only works on 1 cell at a tim

 

[Peo Sjoblom]

Use a help column and a formula

=MOD(A1,1)

will return the time

 

[DNF Karran]

Could you not insert a column and use the function =ROUND([DATE],0)

Dunca

 

[Peo Sjoblom]

I misread the OPs question, to remove time use

=INT(A1)

your formula will round for instance

04/14/2004 12:01:00

to 04/15/2004

--

Regards,

Peo Sjoblom