If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE
=TEXT(F19,"#,0")
and, no, you can't format within the TEXT function. -- David Biddulph "Gary" wrote in message ... 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? |
#3
|
|||
|
|||
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE
=TEXT(F19,"#,0")
No, you cannot bold and underline within a TEXT function. Gord Dibben MS Excel MVP On Fri, 25 Dec 2009 10:26:01 -0800, Gary wrote: 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? |
#4
|
|||
|
|||
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE
On Fri, 25 Dec 2009 10:26:01 -0800, Gary
wrote: Also, is it possible to bold and underline within a TEXT function? No. But more particulars might help solve your problem. You can bold and underline the entire cell either as a "hard" format or with conditional formatting. You can also put an equivalent of your TEXT function into a VBA Macro, and then bold/underline a portion of the text string that you would have your macro write to the cell. --ron |
Thread Tools | |
Display Modes | |
|
|