I have a text box linking to cell A4 that contains '$20,000', but the text box is displaying '20000'. I'd like it display the exact same thing that is in the cell. I figured out how to add the $ by making another cell ='$'&A4', but I cannot figure out to make sure the comma is included. The 20,000 value can change and I'd like the text box to change too. Thanks in advance!
Last edited by dadevil; 05-13-2011 at 05:34 PM.
Any ideas?
dadevil,
Something like this?
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
The textbox is linked to a cell that is actually a combination of text and numbers. so im not sure that the format code would work.
If the cell is a combination of text and #'s, Excel should see it as a string (i.e. text) and bring it across just as it is. Can you upload an example spreadsheet (just showing those two things cell and textbox)?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
The chart has two text boxes to calculate the distribution totals. The text box on the left references a cell, but doesn't have a comma for the number. The text box on the right was manually typed, has no reference, and has a comma. Ideally, I'd like to have it reference a cell, so that it will update automatically when the amounts change, and also include seperators for numbers over 999. Thanks!
I don't quite get what your issue is but I can add my little grain of salt to the salad. Your formula on G9 should provably look better the following way:
=F6&" - "&DOLLAR(SUM(G3:G4),0)
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
I guess I understood the issue after all...Glad it helped
Last edited by ron2k_1; 05-13-2011 at 07:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks