I have this function on E1,

=TEXT(B1-A1),"$ #,##0.00")&" - "&TEXT(D1/C1),"0.00%")

I cannot work with the numbers that E1 provides because they are formatted
as text.

Is there a way to format the numbers in two different ways ($,%), just like
my function, but to actually be able to work with these??