Currency Number Format
How often do you format numbers on your worksheets to currency format? Here’s an Excel tip that’s easy to use and easy to remember.
Pressing Ctrl+Shift+$ will apply the Currency format with two decimal places and negative numbers in parentheses to the cells you have selected. This works in the UK to format £. Remember is it Ctrl+Shift+4 ($ not £). Excel format to you default or local currency.





