Thread: i want to use military format for time e.g. 07:00 as 0700
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default i want to use military format for time e.g. 07:00 as 0700
If you wish to enter time as 0700 and have it a valid time you must use event
code.

See Chip Pearson's site for this.

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


Gord Dibben MS Excel MVP

On Sat, 17 May 2008 20:15:01 -0700, awais
wrote:


Reply With QuoteReply With Quote