Thanks in advance, been looking at other post and couldn't quite get it to
work.

So what I need is such;

Cell A1 = "Number" then cells A2 through A14 are formatted as numbers with 2
decimal places. Otherwise they are numbers with no decimal places. I also
need both number formats to have the "," seperator.

I also keep the worksheet locked with some of the cells unlocked. In order
for this macro to work would I need to have the entire sheet unlocked, just
the cells, or neither.