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.
$___.__)