| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date and time format
Hi, I'd appreciate a solution if any to my query.
I have entered a date and time in a cell as (9mar09 24:00) The cell is formatted to show date and time and it correctly reads it as 10th Mar 09 00:00. However I want the cell to show me 9th Mar 09 24:00, which is really the same time. It is not happening, is this possible to do, appreciate your help. Sorab |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time and Date Format | Excel Discussion (Misc queries) | |||
| Date Format (No Time) | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Threaded Mode
