View Single Post
  #2   Report Post  
JB2010
 
Posts: n/a
Default automatically insert date and time into excel]

Maybe you can program it to input the:

=NOW()


function when it is imported?

just a thought

"slimvices" wrote:

I am planning to import data dirctly into excel via a tcp/ip port(winwedge or
similar)
every now and then a line of comma seperated text will be collected into a
row of cells in the spread sheet
is there any way of getting excel to add date and time information to each
entry, as the device that the data is being colected from has no realtime
clock.