Hi!

I have an energy meter (one of those your put in a wallplug, so you can see the energy consumption of an electrical device).

The logger saves data on a SD-card as a .CSV file, but the kWh counter seems to be locked to 16 bits, since it counts up from zero towards 32,767 kWh,
then it starts over from -32,768 kWh and counts up to 32,767 kWh again and so on.

Now i could just add 32,768 too all the negative numbers to get all positive numbers, but it writes the number as "-32.-768".

So basically my question is: is it possible to convert a number with a negative decimal number, to a normal negative or possitive number in excel?

I know some VBA programming aswell if anyone has a solution through that.

I hope my english will do as it is not my first language

Best Regards
S. Rafen