Thread: Using TEXT and &TEXT - display numbers with commas, underline text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
  
Posts: 273
Default Using TEXT and &TEXT - display numbers with commas, underline text
I'm familiar with the TEXT function, but sometimes a number will display
incorrectly when I format numbers to display with a comma if 4 digits or
more. For example, TEXT(F1,"0,0") will display 10 thru 999 correctly and
displays 1000 correctly as 1,000, but displays 1 thru 9 as 01, 02, etc.

Also wondering how to format part of a TEXT formula to underline, and bold
or color selected words.
Reply With QuoteReply With Quote