Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and time
I want to change the way the date and time appears in a spreadsheet. I am
now geeting military time and a y/m/day format. I want to show the time in a 12Hr. format and the date as Jan. 30, 2008. Itried to cange it in the control panel but it did not chage when I placed the formula in the spreadsheet. Ii looked ok in the dialog box in the control panel but in the sheet it came up incorrect. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |