Hi Libby,

To force a 0 to display after the decimal, you can use the TEXT function to format the result of the ROUND function. Here's an example:

1. =TEXT(ROUND(C29*(92%),1),"0.0") & "-" & TEXT(ROUND(C29*(108%),1),"0.0")

In this formula, the "0.0" format code tells Excel to display one digit after the decimal, and to display a 0 if there is no digit to display. The "&" symbol is used to concatenate the two results with a hyphen in between.

If you have any macro or Visual Basic code, wrap it in the tags.