Thanks boss
Sent from my BlackBerry® smartphone from Airtel Ghana
-----Original Message-----
From: "dguillett1" <dguille...@gmail.com>
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Feb 2012 09:50:15
To: <excel-macros@googlegroups.com>
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
See attached
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Monday, February 06, 2012 9:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
Hi Experts
I am trying to have a currency symbol in front of a value anytime i select the
currency as demonstrated below (file attached also), the problem is am able to
achieve that however, i get so many decimal places so i tried using the text
function to reduce it to two d. places, but when i insert the text formula, i
dont get the symbol anymore, can anyone pls help on this , thanks
3 C. SYMBOL CURRENCY AVERAGE BUYING SELLING 2.6241
$ DOLLAR($) 1.66385 1.6467 1.681
€ EURO(€) 2.17605 2.1541 2.198
£ POUND(£) 2.6241 2.5968 2.6514
GH¢ CEDI(GH¢) 1.0000 1.0000 1.0000
POUND(£) Equivalent
200,000.00 £76216.6075987958
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
