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.
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.
Eveniet eaque id alias voluptatem saepe. Est beatae et consequatur. Modi voluptatem aperiam itaque et.
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...