Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dot as time separator
How can i change the default setting for the time format from ":" to "." for inserting time on num pad? -- moskito ------------------------------------------------------------------------ moskito's Profile: http://www.excelforum.com/member.php...o&userid=27813 View this thread: http://www.excelforum.com/showthread...hreadid=473229 |
#2
|
|||
|
|||
You can set it up to work *temporarily* that way using "AutoCorrect".
Works well if you're entering timecards on a Monday morning, and you wouldn't need it again till next week. Just go to: <Tools <AutoCorrect And set it up to replace the period (decimal) with a colon. When you're done, just change it back. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "moskito" wrote in message ... How can i change the default setting for the time format from ":" to "." for inserting time on num pad? -- moskito ------------------------------------------------------------------------ moskito's Profile: http://www.excelforum.com/member.php...o&userid=27813 View this thread: http://www.excelforum.com/showthread...hreadid=473229 |
#3
|
|||
|
|||
Thanks. It works :) And wen i change ":"with ".." in autocorrect, it allows to use as not temporarily. -- moskito ------------------------------------------------------------------------ moskito's Profile: http://www.excelforum.com/member.php...o&userid=27813 View this thread: http://www.excelforum.com/showthread...hreadid=473229 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Time Sheets | New Users to Excel | |||
unmet challenge | Excel Worksheet Functions |