I am trying to find how i can edit text and formaulas in a single cell.
for example
A1 - 10000
A2 - 3
A3 - ="The answer to the question is " & A1/A3
this will give the result "The answer to the question is 3333.333333
if i change it slightly to
="The answer to the question is " & round(A1/A3,0) I get ......3333
but I would really like get .........3,333
is there an equivalent function like FORMAT(xxxx,"0,000")?
can anyone tell me how to do this?
thanks
john
for example
A1 - 10000
A2 - 3
A3 - ="The answer to the question is " & A1/A3
this will give the result "The answer to the question is 3333.333333
if i change it slightly to
="The answer to the question is " & round(A1/A3,0) I get ......3333
but I would really like get .........3,333
is there an equivalent function like FORMAT(xxxx,"0,000")?
can anyone tell me how to do this?
thanks
john





























Linear Mode

