Formatting a cell's value is often easy enough.

Right now I have a somewhat trickier assignment. Next to a column with decimal separated values (i.e0,87 3,21 12,03) I need to convert the values to 00:87 03:21 12:03.

Been trying my way around formatting the cells, and doing isnert specials, but sitll have't worked it out. Any suggestions while I keep trying different ways are much appreciated.

Cheers, T

Try the SUBSTITUTE() Function.

=(A1,",",":") where A1 is the cell where you have the value 0,87 3,21 12,03
the result will be 0:87 3:21 12:03 (how you got the value 0,87).

The result will appear in the Cell where you enter the SUBSTITUTE() Function. The original value will remain where it is.

You can copy paste the expression down all the rows to covert all values.