How to format the various Date and Time Entries supported by Excel. Is it also possible to format the Date and Time based on Various Time Zones?
1 Answer(s)
Binny
- Enter the date in Excel and right-click on that cell.
- Go to Format Cells and under Number option, select Date to choose any appropriate Date format.
- Similarly, you can also select Time, choose any format and location. Then click Ok.
May 31 2014 10:43 PM
- Go to Format Cells and under Number option, select Date to choose any appropriate Date format.
- Similarly, you can also select Time, choose any format and location. Then click Ok.