Divide two double type data in VBA with keeping the formula

[szejc]

DA,

I have a question with the following problem.
I would like to divide two numbers (stored as Double), but also would like to keep them separately in the cell, so when you select the cell you can see: "=12,33/1,2342" (example)

Please Login or Register  to view this content.

Thank you for your help in advance.


BR,
Daniel

[Crooza]

Have you tried changing the + to an &

From this

T4BCell.Value = "=" & T4ANumerator + "/" & T4ADominator

To this

T4BCell.Value = "=" & T4ANumerator & "/" & T4ADominator

[Tsjallie]

If you replace the + by & and remove the = it should work fine.
But remember that the content of the cell will be text and no longer be double.
You cannot put more than one value in a cell.

[szejc]

Hi Crooza,

Yes, I've tried (actually I started with that one), but later I chose to try everything I could, but nothing helped me .

I tried:
- change double data type to string
- change double to integer (in that case it worked, but integer doesn't have decimal, therefore it wasn't good for me)

My guess is that the problem is behind the decimals so I tried to convert the decimal from "," to ".", but this wasn't good either.

[szejc]

You are right, it worked w/o the "=".

However what I received now is not good for me either.

What I need in the cell:
e.g.: 2
What I need in the function field when I click on the field is: =6,5/3,25

[Crooza]

This code works. puts the =6.5/3.25 in the cell(and the formula bar) but the cell displays 2

Please Login or Register  to view this content.

[Crooza]

here you go this should work for you

Please Login or Register  to view this content.

[szejc]

Crooza, U R awesome

This helped a lot.

Note:
I needed to extend this to work with the following due to the decimal separator differences:

Please Login or Register  to view this content.

Thank you once again.

BR,
Daniel

[Crooza]

Great. Glad it worked. Don't forget to mark it as SOLVED