Buzz
Similar to number formatting, formatting VND currency in Excel is a task that helps you save a lot of time in setting up financial budgets. However, not everyone knows how to do this formatting. Understanding that need, Mytour introduces to you an article guiding how to format VND currency in Excel as well as how to remove that formatting right below.
How to format VND currency in Excel in 3 simple steps
To perform VND currency formatting in Excel, you can follow these 3 steps:
Step 1: First, open the spreadsheet and select the row, column, or cell data you want to format. Then, on the menu of the Home tab, find and select Format. (For many versions, this item will be called Orientation).
Step 2: Next, you click on the Format Cells option at the bottom.
Step 3: In the Format Cells dialog box, you proceed to the Number tab. Then, in the Category section, you select Custom. Finally, you enter the #,##0 'VND' sequence into the Type field and click OK to complete.
Additionally, you can open the Format Cells dialog box to perform VND formatting in Excel as follows:
- You can use the Ctrl + 1 key combination to instantly access this dialog box. This method is particularly useful for those who prefer using the keyboard rather than the mouse.
- You can also select the data range you want to format as currency and then right-click on it. From the displayed list of options, you can find and select Format Cells.
Popular Ways to Format Currency in Excel
In addition to the above method, there are other ways to format VND in Excel such as using shortcut keys or utilizing the Currency option. How are these methods operated? Mytour will introduce them to you right below:
Using the Currency option
Another convenient way to format VND currency in Excel is to use the available system options without needing to input detailed information. The process is as follows:
Step 1: First, open the Format Cells dialog box using one of the methods instructed earlier.
Step 2: Next, in the Number tab, select the Currency option to utilize Excel's pre-defined settings.
Step 3: At this point, you will see a series of options to choose from. Select the one that suits your requirements and then press Ok to complete. The specific contents of the options are as follows:
- Decimal places: This is the number of digits displayed after the decimal point in the decimal part.
- Symbol: You can select a currency symbol from the available options by clicking the down arrow to the left of this box.
- Negative numbers: How negative numbers are displayed according to your preference.
Using Shortcut Keys
One shortcut to quickly format VND currency in Excel that you may not know is Ctrl + Shift + 4. To use this feature, simply select the cell or data range you want to format and press the aforementioned key combination. However, this method only works with the $ currency unit. For other currency units (including VND), Excel currently does not have a predefined shortcut key. Therefore, you can only use the manual method as instructed above.
How to Remove VND Currency Formatting in Excel
Removing VND currency formatting in Excel is quite similar to setting it up. This operation is easily done through the following steps:
Step 1: First, you select the data range that needs to remove VND currency formatting. Then, open the Format Cells dialog box using the methods instructed above.
Step 2: Next, in the Number tab, select General in the Category section (the first option).
Step 3: Finally, press OK to complete the process of removing VND currency formatting in Excel.
Fixing ##### Error When Formatting Currency and Its Solutions
If you've tried applying the methods to format VND currency in Excel as instructed by Mytour above but encountered the ##### error issue appearing in the cells, don't worry too much. The cause of this problem is usually due to cells not being wide enough to display the entire content inside.
To fix this situation, you just need to move the mouse pointer to the boundary between two columns and drag them out to make them wider. Alternatively, you can also double-click on the column divider lines to let Excel automatically adjust the size of the columns to fit the content in each cell.
Furthermore, to perform the above operations in Excel more efficiently, you should equip yourself with a quality laptop. Some affordable laptop models suitable for you include:
Above is the guide on how to format VND currency in Excel as well as how to remove that formatting. Hopefully, with the above sharing, you will be able to perform these tasks more easily. Also, don't forget to follow Mytour daily to receive more useful tips on office computing.
