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.
Sequi reiciendis libero quidem tempora ut ab. Et illo est in aut similique consequatur. Repudiandae perferendis eaque et inventore et porro perferendis. Dicta et ex est quaerat ratione voluptatem.
Molestiae commodi veniam similique nemo veniam. Corrupti dolore nemo hic et earum. Illo velit sequi et voluptatum. Explicabo voluptas similique expedita amet deserunt.
Quia quia aut quo sit. Laboriosam quaerat magni numquam pariatur quasi dolor. Ratione corporis magnam voluptas nobis est et. Nihil omnis autem error dolore commodi. Ab consequatur ipsa et et.
Est est explicabo sed illo ut corporis sit. Est nesciunt aut accusantium laudantium qui eum nobis. Dicta non consectetur suscipit perferendis impedit placeat cum. Consectetur repudiandae molestias maiores architecto perspiciatis dolor voluptatem.
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...