Allow a Range of Cells to hold same decimal formatting as one specified cell

[SoteriaLive]

For example:


cells:

E4,G4,I4,K4,M4,O4

will want to imitate exact decimal formatting of cell E2.

Keep in mind that E2 can have a variety of values.

For example:

36.125
37.50
so on.

Trailing zeros are not needed but I also do want these numbers to maintain exact value of E2.

I am sure this is simple but I have no real skill set in VBA yet but I am learning.

Thanks in advance!

[JieJenn]

Not really quiet understand your problem. SO E2 can have different formatting?

[SoteriaLive]

Yes, but more importantly the decimal formatting must be imitated to cell range to preserve integrity.