If you type a number into an unformatted cell in Excel, that number is stored in the Double data type. When you format that number, you show it in a specific way, but you don't change the number. For instance, if you format the number 1 as a Comma style, you get 1.00. [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/10/08/the-currency-format/
Posted
Oct 08 2009, 06:37 PM
by
Daily Dose of Excel