Using TEXT and &TEXT - display numbers with commas, underline text

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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.
 
Maybe you want:

=text(f1,"#,###")
or
=text(f1,"#,##0")

If this doesn't help, maybe you could post the values and what you want to see
for a few examples.
 
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.
Click to expand...

See Dave's response
Also wondering how to format part of a TEXT formula to underline, and bold
or color selected words.
Click to expand...

That is not possible with the TEXT function.

That is only possible using a VBA macro to output a text string to the cell,
and format what you wish. But more information is needed to help you implement
that
--ron
 
Back
Top