Question

Locked

Excel

By rajakonar ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Not sure if this will help but....

by bart777 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

Collapse -

Set your default country/region....

by ThumbsUp2 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.

...

Related Discussions

Related Forums