This is what I've typed in the box.... =E26-F26 &" to " &E26+F26
This is what it spits out..... -1.17075733089629 to 0.933302652016837
This is what I want it to spit out .... -$1.17 to $0.93
I can't seem to format the box... probably because the text is in there?
Help.
hi. you can't format it because it is now a text. even without the " to ", using the ampersand or concatenate makes it a text. so:
=TEXT(E26-F26,"$#,##0.00") &" to " &TEXT(E26+F26,"$#,##0.00")
or if you dont mind brackets for negatives:
=DOLLAR(E26-F26,2) &" to " &DOLLAR(E26+F26,2)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hey thank you, but for some reason neither of those worked. I received an errors...
wait where should I type this code into? the box or somewhere else?
Replace your formula with the formula provided by benishiryo
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
yeah I put benishiro's formula in and I got an error. where am i supposed to put it in? in the box right? I suck at this.
In your profile please make it as Open Office instead of Excel 2003.
Because both are seems to be similar but may have different methods and definitions.
sure , I will
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks