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"


Comments

Post a Comment

Popular posts from this blog

python - matpltolib navigation toolbar edit curves and parameters line color automatically changes issue -

-
let's consider axis has multiple lines colors such blue, green, yellow, red, magenta, cyan etc. when user selects curve , presses ok without changing anything, automatically yellow , green colors changed slight difference. this happens yellow, green colors. import sys import numpy np matplotlib.figure import figure import matplotlib matplotlib.use("qt4agg") matplotlib.rcparams['backend.qt4']='pyside' matplotlib.backends.backend_qt4agg import figurecanvasqtagg figurecanvas, navigationtoolbar2qtagg navigationtoolbar matplotlib.figure import figure import pyside pyside import qtgui, qtcore class myapp(qtgui.qmainwindow): def __init__(self, parent=none): qtgui.qmainwindow.__init__(self, parent) self.widget = qtgui.qwidget() self.fig = figure((5.0, 4.0), dpi=100) self.canvas = figurecanvas(self.fig) self.toolbar = navigationtoolbar(self.can...
Read more

node.js - Nodejs javascript implementation of PBEWithMD5AndTripleDES/CBC/PKCS5Padding -

-
in order write simple nodejs app talking server written in java have implement following functionality nodejs. public class crypto { cipher decipher; byte[] salt = { (byte) 0x01, (byte) 0x02, (byte) 0x03, (byte) 0x04, (byte) 0x0a, (byte) 0x0b, (byte) 0x0c, (byte) 0x0d }; int iterationcount = 10; public crypto(string pass) { try { keyspec keyspec = new pbekeyspec(pass.tochararray(), salt, iterationcount); secretkey key = secretkeyfactory.getinstance( "pbewithmd5andtripledes").generatesecret(keyspec); ecipher = cipher.getinstance("pbewithmd5andtripledes/cbc/pkcs5padding"); algorithmparameterspec paramspec = new pbeparameterspec(salt, iterationcount); decipher.init(cipher.decrypt_mode, key, paramspec); } catch (exception ex) { } } } i use crypto module of nodejs var crypto = require('crypto'), pass = new buffer(wek), salt = new buffer([0x01, 0x02, 0x03, 0x0...
Read more