Microsoft Office Forums - View Single Post - [Solved] Custom format 4 digit number to 0:00

Thread: [Solved] Custom format 4 digit number to 0:00

View Single Post

Old

06-05-2021, 04:30 PM

Marcia

Marcia is offline

Marcia uses Windows 10

Windows 10 Marcia uses Office 2019

Marcia uses Office 2019

Office 2019

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Custom format 4 digit number to 0:00

Hi. Is there a way to format a number, say when the number 230 is entered, 2:30 should appear and 1130 to 11:30? I tried typing #0:00 in the custom format option but got an error message.
Thank you.

Reply With Quote