Thread: Formatting cell with text and formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AHizon via OfficeKB.com AHizon via OfficeKB.com is offline
external usenet poster
  
Posts: 23
Default Formatting cell with text and formula
I have the below formula:
=IF(K52=181044, "OK", "Off $" & 181044-K52)

Even after I format the cell to not have decimals, it still displays the
decimals to the 13th exponential. How can I set it so that it maxes at 2
decimals even if the cell has text and numerical value?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

Reply With QuoteReply With Quote