eHow launches Android app: Get the best of eHow on the go.

How to Format Cell Numbers in Excel

Video Preview

Summary: Format cell numbers in Excel by highlighting the cells and clicking one of the format icons on the toolbar. Format cell numbers in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.

Views:
567
Presenter
By Amar Enhsaihan
eHow Presenter

Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more

Post a Comment

Post a Comment

Video Transcript

"Hi, I'm Amar Enhsaihan, I'm going to show you today how to format cells in Excel. I have my example open, so here are the numbers I'm going to format and here are the formatting options. I can turn them into dollars, turn them into percentages, separate them by commas, whenever it's like large number, it's easier to see if you separate them by commas. And then you have digit options. You can make it as many digits as you want or no digits at all. And I can show you an example. So let's say, I want this to be a dollar, click on it, press dollar sign, it's a dollar. If I don't want any digits, I take away the digits like this or give it back to them, like this. If I don't want it to be a dollar, I want to show it as a percentage for some reason, then I click the percentage, here it is, percentage. And that's how you format cells in Excel. I'm Amar Enhsaihan, thank you for watching."

eHow Article: How to Format Cell Numbers in Excel

Related Ads

  • Have you done this? Click here to let us know.
Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics