Prev: Merry Christmas!
Next: "File Error: Data May Be Lost" when file saved on Mac is opened in Windows
From: Gary on 25 Dec 2009 13:26
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?
From: "David Biddulph" groups [at] on 25 Dec 2009 14:22
=TEXT(F19,"#,0")
and, no, you can't format within the TEXT function.
--
David Biddulph

"Gary" <Gary(a)discussions.microsoft.com> wrote in message
news:BB1D43CA-59AD-4200-A7BD-9282D6B5DA32(a)microsoft.com...
>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?


From: Gord Dibben on 25 Dec 2009 15:25
=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 <Gary(a)discussions.microsoft.com>
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?

From: Ron Rosenfeld on 25 Dec 2009 16:36
On Fri, 25 Dec 2009 10:26:01 -0800, Gary <Gary(a)discussions.microsoft.com>
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
 | 
Pages: 1
Prev: Merry Christmas!
Next: "File Error: Data May Be Lost" when file saved on Mac is opened in Windows