How to keep % formatting when pulling data from another cell


I have information in 2 cells which I need to pull into one cell. One of the 'feeder' cells contains a number in % format the other is just text. When I pull them into my combined cell, the muber loses its % format. Is there a way to retain it? Thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!