matthewtball
New Member
- Joined
- Sep 9, 2008
- Messages
- 1
I have a spreadsheet that has a column that has a date such as 0510; which represents YR MO. I would like this column to display as follows: 2005 October.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
newbie - custom format help
- Thread starter matthewtball
- Start date
-
- Tags
- custom format
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Hello matthew, welcome to MrExcel
Unless your data is already a formatted date - i.e. formatted as yymm - you won't be able to do this with cell formatting. Assuming that there will always be 4 digits, and that data is text formatted and represents dates from 2000 onwards you could try this formula to convert in another cell
=TEXT(TEXT(20&A1&"01","0000-00-00"),"yyyy mmmm")
[edit: where A1 contains your data]
Unless your data is already a formatted date - i.e. formatted as yymm - you won't be able to do this with cell formatting. Assuming that there will always be 4 digits, and that data is text formatted and represents dates from 2000 onwards you could try this formula to convert in another cell
=TEXT(TEXT(20&A1&"01","0000-00-00"),"yyyy mmmm")
[edit: where A1 contains your data]
Last edited:
Upvote
0
Similar threads
- Question
