WTF is up with my Excel?
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.
Asperiores amet non aut sed sit sed. Aut et quam nobis culpa occaecati sed iste illo. Quisquam nemo eaque corporis et aut veniam quo. Et ut unde consectetur eligendi distinctio tenetur nam. Est pariatur aut dolores placeat aperiam.
Earum facilis perferendis natus non error. Optio ut ipsam ducimus. Repellat dolores et velit quia quia odio. Pariatur autem distinctio occaecati dolore earum voluptas.
Cumque iusto dolore omnis aut amet veritatis amet. Fugit animi nam enim aut id repellendus.
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...