In excel cell has value "1/28/2007 10:00:00 PM ". when i format the cell as dd-mmm by using custom formating, the formula bar shows the value 1/28/2007 10:00:00 PM but i could see 28-jan in excel. My problem is when i give this value "1/28/2007 12:00:00 AM " i can see date alone but not time. i can see like this ("1/28/2007"). but i cant see the time 12:00 AM How can i solve this problem?
