| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
*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?" |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
*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?" |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
*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?" |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
*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?" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
| Benefits many people - Question | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
