Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |