Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Currency Conversion Us$ In Indian Rupees

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

iHi Guys,

I have a database with me which has currencies in US$ format as follows:

USA - 1,124,594 (US Dollar thousand)

Now I have to convert this value in 2 formats:

1. Indian Rupees
2. US$ Million (for example - 1.00 millions, up to 2 decimal points)

Now I want to go forward tot his as follows:

1. first I want to convert the value in words so that it can be read and understood by anyone in the team.

2. I want the conversion in Indian rupee and US$ as stated in point number 2 above.

Any help will be greatly appreciated!
View Answers     

Similar Excel Tutorials

Display Numbers, Dates, & Times in the Correct Format in Excel
In this tutorial I am going to look at Number formatting. Number formatting allows you to change how numbers are di ...
Display all Formulas at Once in Excel
How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsheet quickly and easily. S ...
Format Any Element of a Chart in Excel
In this tutorial I am going to go through the Format tab in more detail and show you how to Format every element of ...
Convert Numbers Stored as Text to Numbers in Excel
I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situation often happens when you ...

Helpful Excel Macros

Format Cells as a Currency in Excel Number Formatting
- This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Exce
Convert Numeric Dollar Values into Text in Excel - UDF
- Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or tra
Format Cells as an Accounting Number in Excel Number Formatting
- This free Excel macro formats a selected cell as an Accounting number. This means that the accounting number format is
Format Cells in The Number (Numerical) Number Format in Excel
- This free Excel macro formats selected cells in the Number or Numerical number format in Excel. This means that the cel
Format Cells as a Scientific Number in Excel Number Formatting
- This free Excel macro formats selected cells in the Scientific number format in Excel. This means the cell will be put

Similar Topics







How to format a comma from the right of the decimal point in the third
position, then 5th then 7th ie for Indian curency for Lakhs, Crores etc



hi

My Rupee type is Indian Rupees (INR)
Now if i want to convert the Amount to Amount in Words, how do i do this?

For example, 500 - Rupees Five Hundred Only.
Like this i want to convert the amount to Amount in Words.

suriya


Hi,
I am having some data in a sheet containing the values in actual Rupees (Indian Currency). It is to be converted into Rs. in lacs. Pl. give the formula. Data is in 5 columns. Where I have to enter the formula for converting.
Advance thanks for the solution providers.


hi
is there any macro available to spell number in indian currency
i have one addin but its not giving words for "zero value"
please give suggestions

thnks& regds


Hi Guys,

Happy Belated Halloween!

I have a query.

I have two tables, One with Employee Information and expenses paid to them in different currencies and another table with the average currency rate for the month. How do I convert only the totals of each employee to reflect a certain currency in conversion (i.e., Totals shown in SGD,AUD or HKD).



CURRENCY



The need is to generate the subtotal/grand total based on a single currency (either SGD,AUD,HKD), by converting the multiple currencies in accordance to the date. Any ideas guys! Much appreciated.. Cheers to DonkeyOte and the other guys out here..


I want to know the excel formula which convert the any numeric figure into the words of that country's currency ( depends upon the user.)

Say

The figure is 123456.52

Expected result should be:-

Rupees one lakh twenty three thousand four hundred fifty six and paise fifty two only

Is there any excel formula?

Best Regards

Pradeep Kumar Gupta


I am trying to create a formula which will calculate Rupees from USD. However, I cannot find a way to get the formatting correct. The Rupee is typically formatted 10,00,000. While I have seen macros to spell this, I can't find a way to numerically format the result correctly. I realize if I change the Country settings, it will apply to the entire workbook, not just a section of it.


I have some problem in excell as under
i. In Column A1 I wrote 10,250.00 and I wan it into text in B1 column as
Rupees ten thousand two hundred and fifty only and if there is 10,250.70 then
Rupees ten thousand two hundred fifty and Paisa seventy only



If I enter Rs.100/- in Cell1 & I want Rupees Hundred(In words) in another
cell.
Need to know about any formula or formatting.



I have found the below mentioned formula to custom format numbers in Indian comma style of crore, lakhs, thousands. The formula does not provide desired results for negatives. Also I am in need of mentioning the negatives in paranthesis i.e negative no. of 1 crore as (1,00,00,000.00). Please give the solution to the above.

[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

Please provide detailed solution since I have only basic knowledge in excel and have not dealt with macros programming.


which formula I use for number or currency convert into text or words
like ($10220.00) convert into (Ten Thousand Two Hundred Twenty US Dollars &
Zero Cents Only).



Hi

I have some data where the dates are in IST(Indian Standard timing) and I want to convert this to EST(Eastern Standard timing). Can anyone help me out in this?


Hi,

Can anyone help me getting formula to convert Pacific Standard Time (PST) into Indian Standard Time (IST). The result should show time in AM/PM

Thanks in advance.


Hi,
Can any one help me to convert numeric into words (without Currency USD,
EURO, just words), e. g.,

15,015.27
Fifteen thousand fifteen and twenty seven only

Rgds
Blackwar



Can anyone help me with this?
I have over 500 Grid ref locations that I wish to convert to Long & Lat

The following Grid ref NO305105 converts to -3.1249666,56.2816999 I have used various web sites which allow you to convert one at a time.

Can I paste my info to Excel and convert to Long & Lat? This will then allow me to convert to Ov2 file for my Tom tom.

Any help greatly appreciated.


Davy


An extension to the Convert function to convert a decimal currency into a
word format (ie. from $51.06 to Fifty One Dollars and Six Cents). This would
be ideal for invoices & other functions.



Hi -

I am losing zeros after the decimal point when I convert currency and percentage numbers to text.

Ex.

Cell TAM!$AA$37 is $25.00 (number formatted as currency, two decimal places)

Formula to convert to text that has necessary formatting:

=TEXT(TAM!$AA$37,"$##.##")

Result: $25.

Any ideas on how I can keep my placeholder zeros when converting from number to text?

Thanks


Hi! I have a list with prices of US Treasury bonds. They are quoted in a partcular way that I would like to convert to decimal form. They are quoted like this eg: 99-02. Now this means that the price is 99 and some decimal. The two first numbers are the number of 32:s. Thus in this case the price is 99 and 2/32. However if there are three decimals eg 99-021 the last digit refers to the number of 124:s. Thus the price is 99 and 2/32 and 1/256. Sometimes There are only two decimals followed by a plus or minus sign eg 99-30+ or 99-10-. The plus/minus indicates that you should add/subtract 1/64. (This is the correct way, I know it seems strange but that is the way it is). Also number of digits before the line (in the example 99 might be one, two or three, eg it can look like this: 5-01, 99-021 or 100-21). Is there any way that I can convert these price quotes into decimal form using worksheet functions? Any help very much appreciated! Thanks a lot in advance!


I want to show the a sum of few numbers in word. For Example-
90.00
25.00
-------
115.00
--------
(Rupees : One hundred and fifteen only.)



In the banking world, a lot of numbers are quoted as 'basis points' - 1/100th or 1%.

it's easy to format whole numbers as "bp", but it's not ideal as you need to convert the decimal number by multiplying by 10,000 to geta whole number and then have a format as Code:

#,##0" bp";[Red]-#,##0" bp"


Is there a way to automatically scale a number using a format, so that 0.0065 can be formatted as bp? I've large tables of interest margins that need formatting as bp but will be used in revenue calculations, and don't want to replicate them needlessly

I know you can do thousands and millions, but can't see a way to do it in single magnitudes


i've been trying to figure this out on my own but seem to be hitting road blocks.

i have a column of numbers that we extracted from a database as whole numbers. for instance, 30 should be .30 and 100 should be 1.00. when i try to increase or decrease the decimal point it doesn't allow me to convert it to those positions.

would any one have a tip of how i can easily convert this? there are over 2000 entries in my excel spreadsheet so to do it manually would take a lot of time/effort.

thank you!


Alright, I've been at this for a few days now and my master excel buddies haven't been able to figure this one out either. So they referred me to Mr. Excel...

Problem:

I'm calculating a variety of cells that have a format of [h]:mm:ss. I'm using this format as it displays the information correctly in the cell and using a normal h:mm:ss format doesn't work. I'm calculating these cells using a =SUMIF(M34:M50000,">00:05:00") formula to sum up the amount of time that occurs that is greater than 5 minutes. The problem occurs when I try to make a calculation or convert this type of formatted cell into a normal number format so that I can make calculations off of it. For example, if the sumif formula returns data "01:30:00" I need to convert that cell into minutes (remember the format is [h]:mm:ss (with brackets)) so that it returns "90" minutes so that I can do another calculation off of the "90" minutes.

The one conversion that got the closest was a =(E15-INT(E15))*1440 convert but it ignores the hour section when their are brackets around the hour in the format and if I remove the brackets the time is not displayed correctly.

Hopefully this is enough explaination and its understandable. Any help with this would be greatly appreciated.

Thanks.
yourcontactsfriend


I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction

for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")

and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8


But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?


Currency Calculator Convert to U.S. $ Select a currency Value In U.S. $ #N/A Convert from U.S. $ Select a currency Value (in U.S. $) Exchange Value

Name In US$ Per US$ Argentine Peso to US Dollar 0.26717 3.743 Australian Dollar to US Dollar 0.77447 1.291 Bahraini Dinar to US Dollar 2.6497 0.377 Bolivian Boliviano to US Dollar 0.14225 7.03 Brazilian Real to US Dollar 0.49164 2.034 British Pound to US Dollar 1.5954 0.627 Canadian Dollar to US Dollar 0.89055 1.123


I am trying to set up an exchange rate calculation in the currency calculator cell C5(where it states N/A on the 1st sheet above using Vlookup). For cell C3, I have a drop down box, that references the names in the 2nd copied sheet. I have assigned range names to the 2nd sheet -Currency_names (column A) and Currency_rates (columns B & C). When I set up the Vookup, it comes back stating the lookup value (C3) is incorrect, contains a constant....can someone help?


Good morning! I am using Excel 2003 and have a column within my spreadsheet that, through a formula, inserts a decimal that has formatting to show as a percent. I would like to know who to convert that number to words. I saw spellnumber (and love it!) but don't know how to edit it so that it converts properly.

Any help you be greatly appreciated!

Thank you!
Marcy