Decimal places in linked cells

[abousetta]

Hi,

Assume I have a formula in Cell A1 and this is linked to Cell A2 so that A2=A1. If the result of the formula is not a whole number then the number of numerals after the decimal are variable. Is there a way to standardize this (e.g. 00.00) without using vba? I know that you can do this cosmetically by using the cell formatting options, but is there a way for the actual number in linked cell to be the number of decimal places I need?

Thanks in advance.

abousetta

[shg]

=round(A1, 2)

=--text(a1, "0.00")

[abousetta]

Excellent. And it even worked when I nested with another formula.

Thanks shg.

abousetta

[abousetta]

Final quick question... can I force a cell to have decimal places if it is a round number (e.g. 3 become 3.00).

abousetta

[shg]

Of course. Format the cell as 0.00

[abousetta]

Thanks shg. The Round function seems to work fine if the formula by itself, but doesn't seem to work if its part of a Concatenate function. Even so, the second option of using Text worked.

Thanks for providing both options.

abousetta