Software·43,883 discussions

Excel

Locked

Dear Sir,

Microsoft Excel is US based and when I make Invoice all shown in $ how
do I change it to any value as per the country please guide to change the
same. It Urgent

Raj

Topic

Clarifications

In reply to Excel

Clarifications

Not sure if this will help but….

In reply to Excel

You’ll probably have to create another cell to do the conversion calculation.

Here is a link that may assist you.
http://www.wikihow.com/Create-a-Currency-Converter-With-Microsoft-Excel

Set your default country/region….

In reply to Excel

Changing the default country/region on the computer changes the standard settings for numbers, currencies, time, and date to those most commonly used for that country/region.

+ Microsoft Windows XP

In the Control Panel, click Date, Time, Language, and Regional Options.

Click Regional and Language Options, and then click the Regional Options tab.

Select the country/region you want to use from the list under Standards and formats.

Click OK, and then restart your program.

—-

Note When you change the country/region, settings, such as the format for displaying currency and date, may also change. Check all the tabs in the Regional and Language Options or Regional Options dialog box to make sure they are correct.

…

[Author]

Replies