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.
| +230 | Should My Intern Get a Return Offer? | 58 | 2d |
| +106 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 18 | 45m |
| +79 | Incompetent and annoying co-intern | 23 | 19h |
| +68 | Getting Laid in IB? | 28 | 3d |
| +66 | Intern keeps sleeping at work - what to tell them | 28 | 22h |
| +55 | Living in greenwich as an analyst? | 12 | 18h |
| +42 | NYC Associate Budget | 14 | 23h |
| +36 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 1d |
| +36 | Quick Thoughts on CVC AI Sale Process | 7 | 1d |
| +29 | Going out / social schedule as AN1 | 14 | 3d |
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.
Sit animi possimus nobis ea. Quas et incidunt odio ut necessitatibus eum. Est minus et ut error maxime nihil libero aut. Corrupti placeat magni quia accusantium. Occaecati consequatur placeat soluta magnam.
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...