We have logged many thousands of values for a point in Volts that should have been, and now are being, logged in kV.
So we need to do a conversion of all the data before "14/11/2016 11:00:00" to be x/1000.
I imagine this could be done in a VB Script in excel
Select data in the date range
read the value
divide by 1000
update the value
save and next
Is this the best way to go ?