#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default military time

My Excel spreadsheet has converted to military time, and it doesn't want to
return to standard time. Other than Format, Cells... any suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default military time

Format | Cells | Number (tab) is the way to do it - what's wrong with
doing this?

Pete

On Mar 19, 2:40 pm, TerryTutor
wrote:
My Excel spreadsheet has converted to military time, and it doesn't want to
return to standard time. Other than Format, Cells... any suggestions?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default military time

Perhaps conditional formatting is applied? Or data validation?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Pete_UK" wrote:

Format | Cells | Number (tab) is the way to do it - what's wrong with
doing this?

Pete

On Mar 19, 2:40 pm, TerryTutor
wrote:
My Excel spreadsheet has converted to military time, and it doesn't want to
return to standard time. Other than Format, Cells... any suggestions?




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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to keep 0 for military time Tory Excel Discussion (Misc queries) 2 September 5th 06 08:29 AM
Military time comes up? kat Excel Discussion (Misc queries) 1 March 7th 06 05:15 PM
Military Time SteveTALL Excel Discussion (Misc queries) 2 December 18th 05 02:38 PM
Show timesheet time in and out in regular time versus military tim John Excel Worksheet Functions 1 November 11th 05 05:14 AM
Military Time Sue Excel Worksheet Functions 2 May 2nd 05 05:45 PM


All times are GMT +1. The time now is 02:32 AM.

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

About Us

"It's about Microsoft Excel"