deleting part of an entry

  • Thread starter Thread starter chris.howes
  • Start date Start date
C

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
 
Could you not insert a column and use the function =ROUND([DATE],0)

Dunca
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
date 1
cell format - not automatically taking effect 4
Excel 2002: How to make the date format uniform ? 1
How to customize =Now() 11
Delete Timestamp 2
Change day of week to day of month 6
years-months-days-hours 5

Back
Top