Hi,

I have a spreadsheet that deals with numbers to different decimal
places at different times. Instead of manually going over the other
cells and changing via format number menus to 2dp or 3dp etc is there a
way to have a key single cell that I can set the format in and the rest
of the cells all follow suit?

IE in cell A1, I have the number 20.000, and in A2~A10 I have a range
of other numbers that will automatically adopt the 00.000 dp placement?

Thanks,

Slash.