November 07, 2011

Format cells in excel for typing a number as currency


Problem: How to automatically format cells in excel for currency

Format Cells - Number - Custom
Type for euro:
#.##0,00 "€"

or some other currency;
#.##0 "LEK "

No comments: