Seconds format

[pmguerra]

Hi

I want to quickly introduce seconds and decimals in a cell without the need to introduce minutes.

I've tried formatting the cell to "ss,00" but Excel assumes format as a date.

thanks for your help

[AlfD]

Hi!

What are you putting into the cell and what do you want the output to be and to look like?

Alf

[pmguerra]

I'm introducing seconds but the cell format is "mm:ss,00". I have to introduce the "zero" for minutes and then introduce seconds.

Example: for 25,43 sec. I have to introduce 0:25,43. If I introduce 25,43 it assumes it is a date format.

The output is seconds also.

My problem is the cell formatting...

[AlfD]

Hi!

Format the cell as number with 2 decimal places. I assume "," is your decimal separator.