Ask Your Question
0

how to format 10/19 as October 2019

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

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
0

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

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

Comments

Thanks. Think I just did the MMMM YYYY thing.

PeeJay gravatar imagePeeJay ( 2019-10-04 20:10:06 +0200 )edit
0

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

PeeJay gravatar image

Never mind. Found a way.

edit flag offensive delete link more

Comments

And what was it, please?

ve3oat gravatar imageve3oat ( 2019-10-04 20:18:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 37 times

Last updated: Oct 04