Hi Ruben
Try this

[D2] = Format([B2], "#.##")

Regards
Andrew Bourke

Ruben Mikkelsen wrote:
Hi

I'm trying to take some numbers i.e 12.1515665 and copy it
to another cell. What I would like to happen is that the numbers
automatically is formatted into 2 decimals ie 12.15. Is there a way to make
that happen.

regards

ruben