advanced formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Formatting

Advanced Formatting

resolvedResolved · Low Priority · Version Standard

Shantell has attended:
Excel Intermediate course

Advanced Formatting

How do you convert into currency

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 (


 

Excel tip:

Quickly select a block of data

To 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.

View all Excel hints and tips


Server loaded in 0.09 secs.