Time Format - AM/PM to am/pm

Use the following custom format:

h:mm a/p\m

I cannot explain why this works, but it does.

It didn't work for me - it kept auto-putting a \ in front of the a/p\m and displaying incorrectly.

It works for me!

Attachment 621595

Originally Posted by EdWoods

Still won't for me.

That's because you have used this:

h:mm \a/p\m

instead of this:

h:mm a/p\m

Excel auto-inserts it.

It doesn't here. Just delete it.

Excel 2016 (Windows) 32 bit

	F
5	4:00 pm

Sheet: Sheet1

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

Try repairing your copy of Excel, then try again.

Originally Posted by EdWoods

Still won't for me.

This is an old thread but since it just popped up again here is Ed's file with the correct formatting. I don't know why you had trouble with it.