Thread: TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
  
Posts: 273
Default TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE
I understand the TEXT function, however when I format it as TEXT(F19,"0,0"),
I get 1,000, displayed correctly. Also 10 thru 999 displays correctly, but 1
displays as 01, 2 as 02. Can I suppress the zero in single digit numbers?
Also, is it possible to bold and underline within a TEXT function?
Reply With QuoteReply With Quote