number/time format
 

can i format a cell so a user enters say 930 and on exit from the cell it
automattically formats to 9:30 (h:mm format)

thanks

sako 338

number/time format
 

See

http://cpearson.com/excel/DateTimeEntry.htm

In article ,
sako 338 wrote:

can i format a cell so a user enters say 930 and on exit from the cell it
automattically formats to 9:30 (h:mm format)

thanks

sako 338

number/time format
 

No, you can't format a cell in that manner.

See Chip Pearson's site for event code that allows this.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 16:05:00 -0800, sako 338
wrote:

can i format a cell so a user enters say 930 and on exit from the cell it
automattically formats to 9:30 (h:mm format)

thanks

sako 338

number/time format
 

thanks, it works great (although i don't understand it fully) but it works

"Gord Dibben" wrote:

No, you can't format a cell in that manner.

See Chip Pearson's site for event code that allows this.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 16:05:00 -0800, sako 338
wrote:

can i format a cell so a user enters say 930 and on exit from the cell it
automattically formats to 9:30 (h:mm format)

thanks

sako 338