Month Name from single number? 1

[jazminecat23]

Hi everyone -

I have a user who has a spreadsheet with exported data. The month is listed as a single number ,1 through 12. She wants to show these on another sheet as the month name
(i.e. 1 = Jan, 2 = Feb, etc). Anyone know an way to do this? Thanks!

 

[SkipVought]

Hi,

Use a lookup table
[tt]
Jan
Feb
...
[/tt]
[tt]
=index(LookupTableRange,MonthNumber,1)
[/tt]


Skip,

_[red][/red]

 

[AnotherHiggins]

Is the rest of the date included in other columns? If so, you can reconstitute the date via formula.

If not, I'd use a formula like this:
[tab]=DATE(YEAR(NOW()),A1,1)
in another column. Then format that column as mmm.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Zathras]

Or, you could use the formula
[tt]
=DATE(2007,Sheet1!A1,1)
[/tt]
and use custom format
[tt]
mmm
[/tt]

 

[Zathras]

Dadgum cross postings!

 

[AnotherHiggins]

Woo Hoo! I beat someone to the submit button!!

This is a rarity....

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[jazminecat23]

Man, y'all are the best. I think just the help I've gotten here this week has saved my sanity, not to mention all the help I've found over the years here. Zathras, yours worked just the way I needed, so have a star, and thank you!

 

[AnotherHiggins]

Not for nuthin', but my suggestion is the exact same thing but it always uses the current year.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Zathras]

Just in case some year they decide to change the names of the months.

 

[AnotherHiggins]

Hey, you never know....

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.