I have a column with computation times in milliseconds. However, I would like to display this column in seconds, without modifying the columns’ contents.
Example:
Current Data:
972
244
430
300075
2863
How I would like to display this:
0
0
0
300
2
So basically I would like to drop the last 3 digits. I tried using the format data code: “#,” but this doesn’t give the desired result. Whenever the original number is less than 1000, I would simply get an empty cell as if the data was missing.
Alternatively, this would also be a good solution:
1
0
0
300
3
These numbers are obtained by dividing the original number by 1000 and rounding to the nearest integer value. This can easily be achieved by creating an extra column, but that seems to me a rather ugly solution?