jescholler
Well-Known Member
I'm trying to create a brewing spreadsheet. What I'm trying to do now is take the low and high gravity for a style and place it in a single cell with a hyphen between (e.g. 1.045-1.060). I have the 1.045 and the 1.060 stored in other cells, lets say A1 and A2 respectively.
Right now, I use the formula =A1&"-"&A2.
The problem is because of the formatting, it results in the cell displaying "1.045-1.06" (without the 0 after the 6).
It's not a huge deal, mainly looks, but there has to be a way for it to display like "1.045-1.060".
Right now, I use the formula =A1&"-"&A2.
The problem is because of the formatting, it results in the cell displaying "1.045-1.06" (without the 0 after the 6).
It's not a huge deal, mainly looks, but there has to be a way for it to display like "1.045-1.060".