How to Add a dollar symbol with Spaces Microsoft Excel

Currency Symbols Data Excel 2007 - One of the office work that requires currency symbol is to the financial statements, for example in the accounting and banking.
Luckily there is software like Microsoft Excel number crunchers that really help us do the job. However, those of you who do not understand may be confused to find a way to write down the currency in Microsoft Excel automatically.
Do you have to write one by one in front of that number? Of course it will spend a long time. So how? Check out the tutorial below.

How to add the dollar signs in front of numbers automatically 

1. The first step must be for you to do is make or have data numbers first. An example is Acer Laptop Price List data in this image. (that's just sample so i just write 5 list for make a quicky ^_^ 
2. A cell block number which will be a symbol of rupiah in front of him, in the picture above is a cell C3 to C7. 
3.  If you have, on the Home tab in the group Number tab, change the General became Currency. See the picture below.
   
   
4.  Then you will get a result like this.
   

How to add a dollar symbol with a space in front of the nominal rate
In the above results, the symbol of the dollar appears to joined to numbers. To make it an integral symbol spacing, with average nominal number format right while left-average currency symbol, then the way is: press CTRL + 1 (number one), select the Custom menu, and choose a custom format like this:

$_* #,##0.00_);(_$* (#,##0.00);($_* "-"??_);_(@_)

 
then double-click and see the results

That tutorial convert numeric data into a currency or currency of data in a Microsoft Excel worksheet, 2007. Please try. If you still do not understand, please ask in the comments below.