DBNum2 in Excel

How to use the DBNUm1 / DBNum2 in Excel ? I have keyed the simple conversion but it doesn't work. Any idea ?

TEXT(8,"[DBNum1]")="¿"
TEXT(8,"[DBNum2]")="¿"

Actually, I want to convert numeric amount into text. What's wrong with the string ?
G25 Value : 1178.65
Result : /¿¿¿¿¿6¿5¿            

=IF(-DOLLAR(G25),SUBSTITUTE(SUBSTITUTE(IF(G25<0,"¿",)&TEXT(INT(ABS(G25)+0.5%),"[dbnum2]G/¿¿¿¿¿;;")&TEXT(RIGHT(DOLLAR(G25),2),"[dbnum2]0¿0¿;;¿"),"¿¿",IF(ABS(G25)<1,,"¿")),"¿¿","¿"),"")
AXISHKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dlmilleCommented:
can you provide a simple example worksheet with what you're attempting?

Dave
0
AXISHKAuthor Commented:
The formula has been bolded with red color.

Thanks
test.xls
0
dlmilleCommented:
What language?

Here's a primer I found on conversions - scroll to the dbNum2 conversion.
http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=%2Fcom.ibm.productivity.tools.help%2Ftext%2Fcommon%2F01%2F05020301.html
Dave
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

AXISHKAuthor Commented:
Simplfied Chinese.
0
dlmilleCommented:
Please advise what you are seeing in cell J27 as I see chinese characters I assume are representing the number.  Is this what I should be seeing?
0
AXISHKAuthor Commented:
No, they aren't.
Actually, I want to see the Chinese numeric word as xx dollor xx cents, where "dolloar" and "cents" will be displayed in Chinese words.

Thanks
0
dlmilleCommented:
So you need help with the words dollars and cents, or just the number formatting as stated in the original question?

E.g., If I show you how to convert a number to simplified chinese using DBNUM can you take it from there?  I don't read Chinese.

Dave
0
dlmilleCommented:
Is this what you're looking for (where you put the chinese words in for dollars and cents?)Is this correct?
Dave
0
dlmilleCommented:
Are you there?  I tested online and the simplified chinese seems correct as 700 dollars and 00 cents.  Or, are you trying to say "Seven Hundred Dollars and Zero Cents"?

Please verify as I'm standing by with some alternatives.


I used this where J54 had the value I was testing.

=TEXT(J54,"[DBNum2][$-804]0") & " Dollars and " & RIGHT(TEXT(J54,"[DBNum2][$-804].00"),3) & " cents"
Dave
0
AXISHKAuthor Commented:
Yes. What's the meaning of" [[$-804]0" ?

Any idea what's wrong with the formula in the Excel file ?

Thanks
0
dlmilleCommented:
If the answer is correct, is there a need to "fix" the formula?

804 is the code number for simple Chinese format conversion:

http://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx

Cheers,

Dave
0
dlmilleCommented:
Translating all of it to simple chinese...

The revised formula for cell J27 should be:

Guidance
See attached worksheet with J27 updated

Cheers,

Dave
test2.xls
0
dlmilleCommented:
Unless I've given you something that is incorrect (though I think your comment "Yes" means it is correct), I'd need help on the characters you have in the formula as I can't translate chinese that fast = would probably take me 30+ minutes to do that.  So if the chinese characters in your formula were converted to english, THEN I could help you parse the formula if what I gave you doesn't suffice.

Also, I think I answered your fundamental question - how to convert a number using the Text function to simple chinese.  by the way, it is impossible to read your original question to see the chinese characters - they all look like upside-down question marks ;)

Do you need additional assistance, or is what I've given you created a direct linkage for you to solve the problem, going forward?  I want to make sure you're getting what you asked for.

Please advise.

Dave
0
dlmilleCommented:
The google translation of my original solution for 700.00 is:

"SEVEN December dollars and cents December" which I believe is right.

-------------------------
Ok - I gave your formula a shot, and hopefully you find this a help.  Would be great if you tell me how close I got, lol:

The revised formula, parsing all the bits together and using your conjunction terms:
repaired?
And, this could be right but the idioms you're using don't directly translate with google, but here goes:  700.00 translated using this new format to:

"The qi Hong common format yuan qi. December" which could be right too?

See attached.

Dave
test3.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.