Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
danlinksman
 
Posts: n/a
Default I want to enter 346 without having to hit shift colan for the col.


  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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

Gord Dibben Excel MVP

On Fri, 3 Dec 2004 15:31:02 -0800, "danlinksman"
wrote:


  #3   Report Post  
CLR
 
Posts: n/a
Default

Format Custom #":"##

Vaya con Dios,
Chuck, CABGx3


"danlinksman" wrote in message
...



  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

With, of course, the caveat that the result is not a time, and you can't do
time arithmetic on it.

On Fri, 3 Dec 2004 19:57:41 -0500, "CLR" wrote:

Format Custom #":"##

Vaya con Dios,
Chuck, CABGx3


"danlinksman" wrote in message
...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"