How to insert symbols and numbers in same cell

Super Contributor

Hello Everyone,

Screenshot (3024).png


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.


2 Replies
best response confirmed by allyreckerman (Microsoft)


Apply the custom number format


_(#,##0.00* "$"_);_((#,##0.00* "$");_("-"??* "$"_);_(@_)


to the cells. See the attached version.


It worked! Thank you so much Sir