modifying a date value in multiple cells

[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?

 

[fredg]

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?

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.

 

[KARL DEWEY]

What about removing the right-most 4 characters?
Left([YourField], Len([YourField])-4)