hip2b2
Board Regular
- Joined
- May 5, 2003
- Messages
- 135
- Office Version
- 2019
- Platform
- Windows
Data and formula are as follows"
I would expect the formula would result in
But instead I get
QUESTION
How do I modify the formula to return the 2nd decimal place (when it is a zero), and include the $ sign?
Cost 1 | $ 2.70 | Group 2 | =CONCATENATE(B3," ["&C3&"] ",D3) |
I would expect the formula would result in
Cost 1 [2.70] Group 2 |
But instead I get
Cost 1 [2.7] Group 2 |
QUESTION
How do I modify the formula to return the 2nd decimal place (when it is a zero), and include the $ sign?