Hello All,
I have a cell that is the sum of 2 other cells formatted as currency, 0 decimal places. This rounds the results to the nearest $. Now the user wants to display the cents ALWAYS as ".00". How do I format this cell to show the zero cents?
Thanks In advance.
Results 1 to 3 of 3
Thread: Rounding Currency (Excel 2003)
-
New Lounger
- Join Date
- May 2002
- Location
- Bronx, New York, USA
- Posts
- 9
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2005-11-07 19:31Rounding Currency (Excel 2003)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2005-11-07 19:36Re: Rounding Currency (Excel 2003)
You could use a custom format <code>$0".00"</code> or <code>$#,##0".00"</code> - the bit between quotes is literal text.
-
New Lounger
- Join Date
- May 2002
- Location
- Bronx, New York, USA
- Posts
- 9
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2005-11-07 19:44Re: Rounding Currency (Excel 2003)
Thanks Hans.
That did the trick.
<img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
