Thread: How do I make into a dollar format when in a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero[_3_] Ed Ferrero[_3_] is offline
external usenet poster
  
Posts: 108
Default How do I make into a dollar format when in a formula?
Hi krissy,

How do I make the 7897.98 w/ a dollar amount? The current formula is " &
c8
& ".

=TEXT(C8,"$0.00")

Ed Ferrero
www.edferrero.com


Reply With QuoteReply With Quote