Thread: Formatting a number as accounting in a text reference.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pradhan Pradhan is offline
external usenet poster
  
Posts: 14
Default Formatting a number as accounting in a text reference.
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.
Reply With QuoteReply With Quote