How can I enter 1/100th of a second into an Excel cell?

Dalex · Dec 4, 2005

I can enter 1/10th of a second but cannot enter 1/100th

Niek Otten · Dec 4, 2005

Format>Cells>Number>Custom
In the Type box, enter h:mm:ss.00

Dalex · Dec 4, 2005

Thanks Niek,

Worked perfecly

Niek Otten said:
Format>Cells>Number>Custom
In the Type box, enter h:mm:ss.00