Hi,

By far the simplest solution is to format B1 as currency but you seem to
have tried TEXT options so if that is what you want try

=TEXT(A1,"$0.00")

Mike

"Pradhan" wrote:

Hello and thank you for your help!
I have a simple task but can't find the solution, best shown by example.

A1=25.00 or 25 or $25.00
B1=The price is& A1.

Result: The price is 25.
Desired Result: The price is $25.00

I've tried various TEXT functions to no avail. Any help would be appreciated.