# in Function

Top of the morning.
The below function inserts a space between the last 2 digits of a number.

6789 in a1 becomes 678 9 and aligns on the left of the cell (text).
=TEXT(A1,"#"" ""0")

Now for the dumb question, what does the "#" do and where could I find this
tidbit of information?

Thanks.
cil

Hello,

Open Excel help, go to answer wizard, type "number format codes",
select that and go to "Decimal places, spaces, colors, and conditions".

HTH,
Bernd

Excel 2002

Hi,
try to use

=text(c2,"#000 0")

hth
regards from Brazil
Marcelo

"CIL" escreveu:

> Top of the morning.
> The below function inserts a space between the last 2 digits of a number.
>
> 6789 in a1 becomes 678 9 and aligns on the left of the cell (text).
> =TEXT(A1,"#"" ""0")
>
> Now for the dumb question, what does the "#" do and where could I find this
> tidbit of information?
>
> Thanks.
> cil
>
>
>
>
>
>

hi better one

=text(c2,"#### #")

"Marcelo" escreveu:

> Hi,
> try to use
>
> =text(c2,"#000 0")
>
> hth
> regards from Brazil
> Marcelo
>
> "CIL" escreveu:
>
> > Top of the morning.
> > The below function inserts a space between the last 2 digits of a number.
> >
> > 6789 in a1 becomes 678 9 and aligns on the left of the cell (text).
> > =TEXT(A1,"#"" ""0")
> >
> > Now for the dumb question, what does the "#" do and where could I find this
> > tidbit of information?
> >
> > Thanks.
> > cil
> >
> >
> >
> >
> >
> >

Got it,
Thanks
<[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> Open Excel help, go to answer wizard, type "number format codes",
> select that and go to "Decimal places, spaces, colors, and conditions".
>
> HTH,
> Bernd
>
> Excel 2002
>