Ask Your Question

how to format 10/19 as October 2019

asked 2019-10-04 19:44:41 +0100

PeeJay gravatar image

Excel converts 10/19 to October 2019. LO apparently won't do this.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-10-04 20:09:06 +0100

PeeJay gravatar image

Never mind. Found a way.

edit flag offensive delete link more


And what was it, please?

ve3oat gravatar imageve3oat ( 2019-10-04 20:18:44 +0100 )edit

answered 2019-10-04 20:07:57 +0100

ajlittoz gravatar image

Calc considers this a string of text. If you don't mind, you can enter 1/10/19 to force numeric (time and date) interpretation. Then you format the cell as MMM YYYY or MMMM YYYY depending whether you want a 3-letter abbreviation or full month name.

edit flag offensive delete link more


Thanks. Think I just did the MMMM YYYY thing.

PeeJay gravatar imagePeeJay ( 2019-10-04 20:10:06 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-04 19:44:41 +0100

Seen: 87 times

Last updated: Oct 04 '19