Pull cell formatting from a master sheet to other sheets

[dukewins]

I am having trouble pulling the cell formatting from a master sheet to multiple sheets. My formula is as follows:

="your property to be, which for the "&MASTER!A1&" tax year is "&MASTER!K8&". This assessment represents a "&MASTER!Q8&""

when it pulls the 5,000,000 in cell K8, to the individual sheet, it pulls 5000000, instead of 5,000,000.

any way to fix this without creating columns that record the information in text only to pull from?

 

[JoeMo]

Change: &MASTER!K8&

to

&TEXT(MASTER!K8,"#,###")&

 

[dukewins]

that worked - thank you

how would you do text percentages, like 10.77% and 2 digit numbers with 2 places, like 83.42

 

[JoeMo]

Just change the format part of the TEXT function; Example for 83.42: &TEXT(MASTER!K8,"0.00")&

 

[dukewins]

Just change the format part of the TEXT function; Example for 83.42: &TEXT(MASTER!K8,"0.00")&

that works for the 83.42.

It does not work for the 10.77%.

 

[dukewins]

that works for the 83.42.

It does not work for the 10.77%.

I hacked it and figured it out. Thank you