Forum Discussion
Solved
How to insert symbols and numbers in same cell
Hello Everyone,
How do I get constant dollar symbol on the right side of every cell and number on the left side of the cell. How do I enter any other symbol and number in same cell on different sides.
Please help..??
Here is the attached file.
Apply the custom number format
_(#,##0.00* "$"_);_((#,##0.00* "$");_("-"??* "$"_);_(@_)
to the cells. See the attached version.
2 Replies
Apply the custom number format
_(#,##0.00* "$"_);_((#,##0.00* "$");_("-"??* "$"_);_(@_)
to the cells. See the attached version.
- It worked! Thank you so much Sir😊😊
