Is it possible to keep the font and other text formatting in a referenced cell? I've created a draft worksheet that the user enters their data into. Some cells have tolerance characters. There is another worksheet in a final format. I've referenced the cells from the draft worksheet but they don't display in the same fonts that they are entered in. Can someone inform me how to have the desired fonts show up in the final referenced cell. I'm using Excel 2001 on OS X.
Thanks
Scott
Thanks
Scott