ExcelBanter - auto add : to a number so can type #### and appear ##:##

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - auto add : to a number so can type #### and appear ##:## (https://www.excelbanter.com/excel-discussion-misc-queries/102327-auto-add-number-so-can-type-appear.html)

Tanya

auto add : to a number so can type #### and appear ##:##

Gord Dibben

auto add : to a number so can type #### and appear ##:##

Tanya

Custom Format ##":"##

But..................this will not be a valid Time if that is what you're trying
for.

Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 13:48:01 -0700, Tanya
wrote:

All times are GMT +1. The time now is 08:52 PM.