ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to format cells in Excel 2007 (i.e. currency format)? (https://www.excelbanter.com/excel-discussion-misc-queries/164963-how-format-cells-excel-2007-i-e-currency-format.html)

DonR

How to format cells in Excel 2007 (i.e. currency format)?
 
In Excel 2007 how do I format cells to show in the currency format (i.e.
$___.__)

Jon Peltier

How to format cells in Excel 2007 (i.e. currency format)?
 
Select the range, press Ctrl+1 (numeral one) to open the format dialog,
click on Number, and find the format you like, or enter a custom format.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DonR" wrote in message
...
In Excel 2007 how do I format cells to show in the currency format (i.e.
$___.__)




helema

How to format cells in Excel 2007 (i.e. currency format)?
 
This really helped me with my software class homework in college!! Thank you
for this skin saver!!
helema

"Jon Peltier" wrote:

Select the range, press Ctrl+1 (numeral one) to open the format dialog,
click on Number, and find the format you like, or enter a custom format.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DonR" wrote in message
...
In Excel 2007 how do I format cells to show in the currency format (i.e.
$___.__)






All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com