View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.
$___.__)