Excel: "Don't Fear The Spreadsheet" - The Dollars and Cents of It: Podcast #1578

The earliest Spreadsheets were designed for accountants. To this day, some of Excel's annoying behavior is to make the accountants happy [but it may not be m...

Transcript of the video:

Learn Excel for MrExcel, Episode 1578 -- The Dollars and Cents of It  

This netcast podcast is sponsored by Easy-XL. “Don't Fear the Spreadsheet” podcast episode number seven: dollars and cents.

Well hey, welcome back to the “Don't Fear the Spreadsheet” podcast I'm Bill Jelen from MrExcel, today's question there's Tyler Nash.

Tyler Nash:

How can I set Excel up so that it always shows dollars and cents?

Bill Jelen:

All right Tyler, excellent question, well hey, most people out there are going to say well hey this is a no-brainer it's this big dollar sign icon here choose that column hit the dollar sign icon and you're good to go but this is one that annoys me, I like to have my numbers right justified and the headings right justified and when I choose that dollar sign they move the numbers over just a little bit so this is something called accounting format which is something that accountants like and if you're not an accountant or you don't work in accounting then why the heck do you like this?

Fine I used to work in accounting and i still hate this format so rather than use the obvious one the one that's right there that's just begging for you to use it, I want to use something called currency. To get to currency, we come to this drop-down open it up and choose currency like that. All right now, say well what's the difference?

First difference, the extra space is not there the dollar sign is right next to the numbers instead of over here on the left hand side the other place where this really comes into in the play is how it handles negative numbers, so I'm going to go into the next worksheet here where I've set up a couple of columns, I'm going to make this one be accounting the easy icon and then currency a couple of extra clicks open and then choose currency and you'll see that for negative numbers the accounting uses parenthesis and that's actually why they don't have that number against the right edge of the cell.

Currency uses a negative sign, a minus sign, so it's your personal preference for me though I like currency I'm actually pretty annoyed that they put the accounting format there instead of the currency format because after all Excel should be tuned to exactly what I want all right.

Well hey, if you're new to spreadsheets, check out the book “Don't Fear the Spreadsheet”, 150 beginner Q &A, three case studies, a crash course in Java you this afternoon. This is the book that makes Excel for dummies looks like it was written for rocket scientists.

Keywords for this video: Bill Jelen, Books, Don't Fear The Spreadsheet, Accounting Format, Currency Format, Formatting for Currency, Dollars and Cents, Money, eLearning, ePub, Excel ...

This video is current as of August 3, 2012

For more resources for Microsoft Excel