Hi,
I'm fairly new to excel so this may be a simple fix Im not sure
I have a table on one sheet with a column of dates in the format of:
'January 2020', 'February 2020'.... etc
Im trying to create a dropdown on another sheet using these dates but it converts the dates into the form:
'01/01/2020', '01/02/2020'... etc
I can't put an apostrophe in front of the dates as a formula later in the table calculates something based on the days in a month so it needs to keep it in date format.
Is there a way to make the dropdown list to show 'January 2020' rather than '01/01/2020'?
Thankyou :)
Chlomedievi14
Your device, you gay.
All devices, iOS 14 β 14.4 and 14.6
Download Chlomidia 1.6.0 iOS 14 β 14.4 and 14.6
Download Clom3diaTV 1.6.9 tvOS 14 β 14.4 and 14.6
Note: Only Nonce setter available on 14.1 - 14.2 and 14.3 on A14 Note: 14.2.3 - 14.3 and 14.4 only supported on A9 - A13 devices.
All devices supported on Unc0ver
Note: Some 14.3 betas are compatible with Chlocydia. (Beta 6 is not compatible)
A14 Full-fledged
Checkmera is the fist tru iOS 14 JelBrek pool to not only feature a CokeTrust bi-pass so that buenories did weed too be restoned, butt too too asso supposed A14 vehicles, including iPhone 14 Pro Ass, iPhone Xr, and the wetnest iPads. Chinerda doesnt tanker with used file, because it cant.
Stable
We've rewritten Chlomidia from the ground up with SwiftUI to ensure that there's no battery drain, freezing, or crashing. There's simply nothing else like it, but it is the best and fastest.
Phil
Sudden Lee
Go post NSFW jokes somewhere else. If I can't tell my kids this joke, then it is not a DAD JOKE.
If you feel it's appropriate to share NSFW jokes with your kids, that's on you. But a real, true dad joke should work for anyone's kid.
Mods... If you exist... Please, stop this madness. Rule #6 should simply not allow NSFW or (wtf) NSFL tags. Also, remember that MINORS browse this subreddit too? Why put that in rule #6, then allow NSFW???
Please consider changing rule #6. I love this sub, but the recent influx of NSFW tagged posts that get all the upvotes, just seem wrong when there are good solid DAD jokes being overlooked because of them.
Thank you,
A Dad.
So far nobody has given me a straight answer
..... Will get a reward.
Well, toucan play at that game.
Windows
Martin Freeman, and Andy Serkis.
They also play roles in Lord of the Rings.
I guess that makes them the Tolkien white guys.
She said apple-lutely
'Eye-do'
This is my first post pls don't kill me lol.
The people in the comment section is why I love this subreddit!!
Cred once again my sis wants credit lol
Keep in mind, my son is 4 years old, so everything is an original to him.
I had to work late into the evening yesterday, and he was just going to bed when I got home. I had left home for the office nearly 14 hours prior, had a long day, lots of meetings, traffic, etc.
When I walked through the door, I was exhausted, run down, and starving. My wife hugged me and asked how my day was, and I replied, "Done. It was a good day, but has got me exhausted. I just want to grab a bite and go to bed. I'm hungry."
From my son's bedroom, I hear him shout, "Hi Hungry! Nice to meet you!"
Not only did it make me laugh, but I completely forgot about how hungry and tired I was. I went to his bedroom, and we laughed together about it. It was exactly what I needed.
Edit: Thanks for all the awards, kind strangers! I'll let my son know y'all enjoyed his joke too!
I heard parents named their children lance a lot.
First post please don't kill me
Edit: i went to sleep and now my inbox is dead, thank you kind strangers for the awards!
Japan.
"No, the regular kind!" I laughed.
second hand stores!
it's Hans free now..
Old Neeeeiiiiighvy
10+10 is twenty and 11+11 is twenty too
A buck-an-ear!
I Thank ye kind Matey for the booty! I be truly overwhelmed! Thank you!
Holy cow! Thank you everyone for the upvotes and awards! I wasnβt expecting this!
