conditional decimal places?

Hi all,

I have a question which would mean a huge time-saver if resolved. Here is what i want/need to do:
I have a column with numbers (say column A) and a column with types of measurements (e.g. m3, m2, kg, piece,...) (say column B).

I need the values in column A to be displayed with a different amount of decimal places, depending on the measurement type column B

e.g if B1 = m3, A1 has to display 7.561, if B1 = kg, A1 has to display 7.3
I can not figure out how to do this, Hopefully this is possible (or is there a work around?).

Thanks!

Naat

p.s. not a native English speaker so sorry if unclear.

Hi Ron,

Thanks for your reply, unfortunately I'm not able to select the "number" tab when selecting format (I only see the "font", "border" and "fill" tabs)...
I'm not exactly an excel expert so I might be doing something wrong...
I attached an image to show you where i got stuck (I have the dutch version of excel for Mac 2011).Screen Shot 2013-08-14 at 5.52.23 PM.jpg

Thanks again.

Regards.

Nathan

OK, thanks for the help, i'll see if i can try this on a pc somewhere...