D4represents the fraction sales value. TheROUNDfunction rounds it to one decimal place. TheAmpersand(&)adds the suffixMafter a space. PressENTERand drag down theFill Handletool. The formatted sales values will be stored as text (not numbers). Read More:How to Format a Number in Thousands ...