answersLogoWhite

0


Best Answer

There are two methods to do what you ask.

1) Format > Format Cells > Number > Time > 13:30 (Type).

2) Format > custom > (Type) HH:MM. [This method will force four places.]

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you set up excel cells to format in the form of time ex XX colon XX so that the user just has to enter digits and no colons?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Who is puchi colon?

mickael colons father hes famous by mickael colon


Do homosexuals suffer from torn colons?

Torn colons have nothing to do with sexual orientation. Anyone can get a torn colon. Gay sex does not cause torn colons.


What section of the large intestine is between the ascending and descending colons?

The transverse colon is between the ascending and descending colons


Anyother name for semi-colon?

another name for semi colons


Who is Yasiel Colon?

He is the man who discovered that the yasiel species of animals had colons.


What does a colon doctor do at work?

a colon doc works w/ colons come on people ever heard of education


Should a colon be underlined?

No, colons should not be underlined. When using a colon, it should be formatted as regular text within a sentence.


Who was the first WWE unified tag team champions?

The Colons Carlito Colon and Primon Colon by beating The Miz & Morrison at Wrestlemania 25


What is Costa Rica money called?

colon or colones


What countries use the Spanish currency Colon?

The currency of Costa Rica is the colón, not to be confused with the currency used in Spain. It is only used in Costa Rica.


What kind of color of a colon in females?

It does not matter the gender, colons are either dark brown or black. Gross.......


Where is the colon located?

The ascending colon runs vertically below the liver. The descending colon runs vertically below the stomach. The transverse colon runs horizontally between the ascending and descending colons and is attached to the bottom of the liver and stomach.