copying date with milliseconds in excel vba -

i copy exact date contained in 1 cell cell. use command:

range("e" & ii).value = range("c" & ii).value

but date format missing milliseconds despite having column formatted using:

columns("e:e").select selection.numberformat = "dd/mm/yyyy hh:mm:ss.0"

i "0" millisecond in e column despite having millisecond value in c column.

thanks , regards

use format:

"dd/mm/yyyy hh:mm:ss.000"

Cap