WTH is up with my Excel? I've been working on a euro model, and anytime I type a number into a cell it defaults to Euro? Its used to be that if I wanted it to be currency, I had to format it as such.
And I can't get it to use the proper European decimal systems... ie. 4.123,0 instead of 4,123.0. When I go to custom format it just fucks it up.
I'm using Excel 2007.
| +82 | What does JEF banker always think they’re EB? | 37 | 46m |
| +72 | PWP acquisition by Piper cancelled | 28 | 18h |
| +65 | Is my MD a grifter? 16 years, 8 firms | 21 | 11h |
| +55 | "Corporate & Investment Banking" Analyst - Why? | 40 | 10h |
| +47 | MS / GS IBD ACs London interview processes run by nationality? | 43 | 13h |
| +43 | No return offer - UPDATE. | 12 | 2d |
| +41 | Article: UBS Wall Street Rebuild Is a Study in Management Failure | 7 | 3d |
| +40 | Moat of modelling in PE/Finance completely vanished; | 12 | 11h |
| +31 | What Are The Best Boutiques 2026/2027 | 16 | 1d |
| +29 | Lack of talent in IB! | 25 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
it could be your pc's regional settings.
start -> control panel -> language (or regional language-- I don't remember which... I'm on my Mac right now) and make sure it's set up correctly. I think that affects what excel defaults to
Yeah, I believe SEC is correct. The changes have to be made in the regional settings of Windows.
http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=181668&d=1032&h=1033…
That wouldnt automatically change all numbers to a Euro. Are you working on a new sheet. Clear the formatting for all cells you plan on typing numbers into. It sounds to me like someone universally formatted your cells to currency / euro. Also, make sure you don't have any backround macros running ( alt + f11) and look for modules on any open or hidden worksheets.
i had a similar problem. i had my accountant fix it
another quality post by London... we need his advice like we need an a**hole on our elbows...
Accountants don't know how to fix Excel models
Even if I create a new blank sheet. If I go to cell A1 type 5 and hit enter it defaults to: €5
Its fucking driving me crazy.
Dignissimos non maiores accusantium sapiente. Aperiam quisquam officia repudiandae suscipit molestiae commodi. Omnis aut ea aut sunt itaque consectetur.
Est inventore facilis aut. Consequuntur doloribus sunt dolor vitae necessitatibus. Qui est numquam dolores ut consequatur ipsum necessitatibus. Voluptas voluptatem totam dolorum qui sed libero.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...