Hi.

I can't figure out how to fix this: When I type in for example, 2000. I want it to correct it to 20:00. I tried every format in 'format cells' and can't seem to figure out the right settings for it.
Anyone knows?

Select the cell, right click and select reset the format of cells, choose times in the category listthen you can correct 2000 to 20:00.

I dont have the option to "reset the format of cells" when I right click.