| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AM / PM Cells
Umm, No! There is a way, I just have to find it
"Teethless mama" wrote: No you can not have without a space between time and AM/PM. Live with it "Chris Cornell" wrote: I can format the cells to AM/PM, however I get a space between the time and AM/PM. EX: 12:00 AM When I try to format the cell without the space, the calculation automatically turns to #VALUE! I would like to try to find a format I can use without requiring me to put a space between my time and AM/PM. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
Linear Mode
