98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Formatting
Advanced Formatting
Resolved · Low Priority · Version Standard
Thu 13 Mar 2008, 16:29Delegate Shantell said...
Shantell has attended:
Excel Intermediate course
Advanced Formatting
How do you convert into currency
Thu 20 Mar 2008, 16:33Trainer Rajeev said...
RE: Advanced Formatting
Dear Shantell
Thank you for attending the Excel Intermediate course. I hope you enjoyed the training.
I am not sure if the question is more specific to 2003 or 2007 version.
To convert cells containing numbers in to currency
In 2003 or previous version is Format > Cells... In the format cells dialog box in the number tab choose currency with the desired number of decimal places.
In 2007 - simply right-click after selecting the cells that you require to be in currency format. Choose the format cells... from the shortcut menu.
And follow the same steps as 2003.
NB: the shortcut key is CTRL+SHIFT+$. This will format all your selected cells to the currency with two decimal places of the regional settings (
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly select a block of dataTo quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8. |
