Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

likesmart
Posting as :
works at
You are currently posting as works at

Alt H N S?

likesmart

OP, did you need me to add ‘Enter’ to my post? Or did you know what to do after hitting Alt H N S?

funny

alt + H + N + S

like

Ctrl + ;

like

Yup, this is it on my machine.

A little more involved, but you can create the following VBA code:

Sub FormatDate ()
Selection.NumberFormat = “mm/dd/yyyy”
End Sub

Then customize the ribbon with a new group and add the macro to it.

From then on, any cell(s) that are selected will be formatted correctly by clicking the new icon on the ribbon.

like

alt f4 y

funny

OmG sO fUnNy KPMG

like

Related Posts

Looking for a nice looking, sturdy, comfortable to carry travel duffel with a cross body strap. I always travel with my Louis Vuitton Keepall 55 bandoulière as a carry on, with mainly my shoes and handbags in it - but i took her in to LV for a repair and due to supply issues she will sadly not be back in time for my trip to Italy in September. (The repair may take 10 months, WTF!) I would appreciate any recommendations, and would love for it to be similar in size to the Keepall 55.

like

How is the job security in @Capco.@Capco

like

How is work culture, work life balance and job security in Nasdaq banglore office for frontend developers Nasdaq
Nasdaq

like

looking for referrals at RBC BMO

like

Am I the only one that things Amex points are total trash? I have a butt load of them and have looked on the points guys recs and none of them look that great

like

Thinking of switching employers. Do you think bigger retail stores (the ones that have several locations) are easier or harder to work at than little hole-in-the-wall grocery stores (which is all I've ever done)? It seems like the larger chain stores would have more downtime, but I'm wondering if anyone could give some input.

like

Hi,
Anyone recently gave IBM assessment , i gave last week and haven't heard back yet
How long does it usually take to get a call for further steps after online assessment?

Kindly suggest

Have you ever stopped yourself from applying to a better jobs (externally) because you like your current WLB? I easy qualify for AD positions but don’t want to sacrifice my time with my child. At the same time I want more $ 😭 (not starving now but just too ambitious)

like

I make $153k as a staff PM. What do others in PM make?

like

Does Accenture Capability Network entertain counter offers? And how do they check if its genuine?

like

Benefits of a book club to drive capability building and thought leadership for teams?

like

What are some large open source structured datasets for our experimenting pleasure?

like

Looks like a promotion could be coming. Wondering what I might expect UX Design Director / in-house finance /Boston / 35

What’s going on with pypl and sq???

like

What blogs/books/resources should I seek out if I want to make the transition from passive trading (index funds/buy and hold blue chips) to more active trading (options, speculation, spending a few hours a week researching, etc)? I’m looking to turn my investing into more of a side hustle

like

Any rhinoplasty surgeon recommendations in the area?

like

I have the chase sapphire preferred card for 12 months. Looking to get the CSR, but the application has a 24month wait after getting a bonus from other sapphire cards. Any known ways around this?

like

Anyone in employment tax? How's that field like? Interesting? What about credits and incentives? TIA

like

So I’m in people ops (for lack of a better term) at a national nonprofit for 3 years now and I am *struggling* to pivot into more traditional HR roles and people ops positions outside of the nonprofit space. Has anyone here successfully made that pivot? What did you find most helpful?

like

Need to get an idea on how much Capgemini pay to their senior manager role.

like

Additional Posts in Excel Genius

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

What are the most typical models you all build

likehelpful

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Hey, tips for where to look for good excel cheat sheets online? :)

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal