Thread
:
Currency in cell ref
View Single Post
#
4
Josh
Posts: n/a
try the text function:
=3DH2&" "&I2&" Units"&" (Ave "&TEXT(K2,"=A30.0")&")"
You can adjust the decimal point and format of your number (i.e. 0.0,
0=2E00, 0,000.00, etc)
Reply With Quote