| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to use military format for time e.g. 07:00 as 0700
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i want to use military format for time e.g. 07:00 as 0700
Hi,
you need to create a custom format. In Excel 2003 select the cells you want to format and choose Format, Cells, Number tab, Custom. On the Type line enter hhmm Cheers, Shane Devenshire Microsoft Excel MVP "awais" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Military Time Conditional Format | Excel Discussion (Misc queries) | |||
| Format cell as military time | Excel Discussion (Misc queries) | |||
| getting military time format within excel | Excel Discussion (Misc queries) | |||
| Can I get 0700 to appear as 0700 in a cell? | Excel Discussion (Misc queries) | |||
| adding military time format | Excel Discussion (Misc queries) | |||
Hybrid Mode
