HP Z3200: Cost overview export to Excel

[JuergenHulverscheidt]

Hi everyone!

I used the option to export the costs overview from the Z3200's Web Server to Excel.
The total cost is a sum of media cost and ink cost.
For total cost, the Web Server shows something like "3.1".
Exported to Excel this is interpreted as "03. Jan" (as shown in the cell) or "03.01.2010" (as shown in the formula line).
If I format the cell to "General", this value is changed into (or shown as) 38719.
The individual costs (for paper and ink) are also interpreted as dates, but the costs per ink color seem to be interpreted as numbers (though they are shown left-aligned).

I'm trying to add up the costs of the most recent 60 print jobs and thought Excel might be the best way to do it, but it turns out to be a little … awkward :-|

Anyone else ever used this function … with success?

Thanks a lot and Happy Easter,
Jürgen

[Dick Roadnight]

Hi everyone!

I used the option to export the costs overview from the Z3200's Web Server to Excel.
The total cost is a sum of media cost and ink cost.
For total cost, the Web Server shows something like "3.1".
Exported to Excel this is interpreted as "03. Jan" (as shown in the cell) or "03.01.2010" (as shown in the formula line).
If I format the cell to "General", this value is changed into (or shown as) 38719.
The individual costs (for paper and ink) are also interpreted as dates, but the costs per ink color seem to be interpreted as numbers (though they are shown left-aligned).

I'm trying to add up the costs of the most recent 60 print jobs and thought Excel might be the best way to do it, but it turns out to be a little … awkward :-|

Anyone else ever used this function … with success?

Thanks a lot and Happy Easter,
Jürgen

¿I would have thought it was just a matter of formatting  the number columns as numbers? "##.##" or whatever?