Prev Previous Post   Next Post Next
  #4   Report Post  
Beccy
 
Posts: n/a
Default

Highlight the cell you want to format. Go up to the toolbar and click on
Format then cells.
Click on the number tab, then under category box go to custom.
Then in the box under the word Type, type in:

hh:mm AM/PM

Then click OK.

This will format the cell you chose to this. So when you type in 9:00 it
will come up as 9:00 AM etc.

Hope this helps.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"