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 |
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 |
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 |
All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com