modifying a date value in multiple cells

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hello,
I am having a problem. The program that we use spits out date time
data with milliseconds, like this: 6/30/2005 09:46:16:296
Excel does not recognize this as a date/ time format. I need to have a
macro to run on the sheet that converts any date/ time that looks like
this to:
6/30/2005 09:46:16

Could someone tell me if this is possible?
 
Hello,
I am having a problem. The program that we use spits out date time
data with milliseconds, like this: 6/30/2005 09:46:16:296
Excel does not recognize this as a date/ time format. I need to have a
macro to run on the sheet that converts any date/ time that looks like
this to:
6/30/2005 09:46:16

Could someone tell me if this is possible?
Click to expand...

Excel? A macro to run on the sheet?

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for Excel. I would suggest you
include your Windows and Office version number in the message.
 
What about removing the right-most 4 characters?
Left([YourField], Len([YourField])-4)
 
Back
Top