TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE

G

Gary

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?
 
G

Gord Dibben

=TEXT(F19,"#,0")

No, you cannot bold and underline within a TEXT function.


Gord Dibben MS Excel MVP
 
R

Ron Rosenfeld

Also, is it possible to bold and underline within a TEXT function?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using TEXT and &TEXT - display numbers with commas, underline text 2
Trying to paste in text like "01" from HTML table as text not numb 3
how do I turn off bold and underline as a default in outlook 1
Applying Bold formatting to one word from a line of text in a Word 0
Macro to save word pages separately as PDF and name them according to text in third line 0
auto-hide rows, cell format (# and @), update cell refs, shade cel 0
How to concatenate 3064 and 01 with 306401 as a result? 11
DCount Records to Display in Form 9

Top