*EASY* question 2!!
BlankAnd as a second thought.
In my A column I need to set it out like this HH:MM (AM/PM) with *no* date, just the time. How could i achieve this? Sorry for my questions but this is the first spreadsheet I have ever attempted Thanks in advance -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" |
*EASY* question 2!!
Hi again!
Select column A. Go to Format/Cells and click on Time (on the Number tab). You can then select which type of time format you would like. Hope this helps. Andy. "Laura ( '_' )" wrote in message ... BlankAnd as a second thought. In my A column I need to set it out like this HH:MM (AM/PM) with *no* date, just the time. How could i achieve this? Sorry for my questions but this is the first spreadsheet I have ever attempted Thanks in advance -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" |
*EASY* question 2!!
Yep...Im so dumb on excel :S
Thankyou!"! -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" <Andy wrote in message ... Hi again! Select column A. Go to Format/Cells and click on Time (on the Number tab). You can then select which type of time format you would like. Hope this helps. Andy. "Laura ( '_' )" wrote in message ... BlankAnd as a second thought. In my A column I need to set it out like this HH:MM (AM/PM) with *no* date, just the time. How could i achieve this? Sorry for my questions but this is the first spreadsheet I have ever attempted Thanks in advance -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" |
*EASY* question 2!!
Laura,
For archival purposes, please try to use more meaningful subject lines. -- Don Guillett SalesAid Software "Laura ( '_' )" wrote in message ... BlankAnd as a second thought. In my A column I need to set it out like this HH:MM (AM/PM) with *no* date, just the time. How could i achieve this? Sorry for my questions but this is the first spreadsheet I have ever attempted Thanks in advance -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com