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.
| +120 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 21m |
| +96 | Americas M&A League Table Q2 Updated | 47 | 1h |
| +72 | Wealthy Parents / Jaded | 24 | 19h |
| +56 | How are hours rn for SA (interns) | 31 | 7h |
| +49 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 1d |
| +47 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 14h |
| +38 | Boutique firm wants access to my LinkedIn? | 34 | 12h |
| +31 | Investment Banking in Mexico | 9 | 16h |
| +26 | MM bottom bucket bonus | 9 | 4d |
| +25 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 14 | 19h |
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.
Esse veniam ipsa blanditiis dolores delectus. Asperiores consequuntur autem non esse reprehenderit saepe ut. Atque vitae excepturi autem magnam quia. Illum nihil earum vero dicta ullam velit sed.
Inventore fuga modi optio commodi. Distinctio quas cumque vitae quis facilis dolor. Quia neque ea ipsam dicta vero dolor.
Sunt natus omnis exercitationem nostrum ab. Sed iure perferendis esse est earum est eum. Sunt eaque fugit vitae id est doloribus.
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...