| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AM / PM Cells
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AM / PM Cells
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AM / PM Cells
This custom number format displayed the time ok for me:
hh:mmAM/PM But I still had to enter the time so that excel would see it as a time (with that space or as a 24 hour clock). (Display is different from value) 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? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AM / PM Cells
Yea that's what I keep getting, because I used the custom format as well and
it works ok with the display. Thankyou though for the help "Dave Peterson" wrote: This custom number format displayed the time ok for me: hh:mmAM/PM But I still had to enter the time so that excel would see it as a time (with that space or as a 24 hour clock). (Display is different from value) 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? -- Dave Peterson |
| 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 | |||
| paste locked cells and unlocked cells in protected sheet | 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 | |||
Linear Mode
