Text and Formulas

[mercysakesalive]

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

Help.

[FDibbins]

try this...
=text(E26-F26,"$0.00"), &" to " &text(E26+F26,"$0.00")

[bebo021999]

=TEXT(E26-F26,"0.00") &" to " &TEXT(E26+F26,"0.00")

[FDibbins]

@ bebo, you forgot the $

[mercysakesalive]

I must be doing something wrong. Neither of these works. I'm pretty sure you folks know what you're talking about. I copyed and pasted your ideas in and I got an error...

[FDibbins]

what error did you get?

Can you upload a sample workbook?

[mercysakesalive]

I get an error 508

[FDibbins]

Are you trying to use this in VBA? a regular formula will not give you that error message

[mercysakesalive]

oh shoot, I'm sorry guys. I'm using open office calc!

didn't seem worth mentioning till now.

[FDibbins]

hahahaha ok

I have not used that, lets try this.

enter just =text(E26-F26,"$0.00") and see what you get?

by the way, you ARE just entering this in a normal cell, right?

[mercysakesalive]

I entered what you just told me to and got the same darn err 508. yes, I am just entering this in a normal cell. tried a few diff cells to be sure. thank you.

[FDibbins]

hmm ok lets try this....

put =E26-F26 in its own cell (I used A1, adjust as needed), then see what this gives you?

=LEFT(A1,IF(A1<0,5,4))

[mercysakesalive]

where am i supposed to put =LEFT(A1,IF(A1<0,5,4)) ????

I put =E26-F26 in its own cell and it spits back the number correctly.

I put =LEFT(A1,IF(A1<0,5,4)) in its own cell and I get an error?