View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sorab sorab is offline
external usenet poster
 
Posts: 7
Default 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