Custom format with text

I want the number 20 to display as
20 WEEKS
I have tried (re Help)
0;;;" WEEKS"@
and various combinations of ; spaces, the lot. Nothing works.
Where is the error?
Thanks,

Hi Pierre,

Select the column in which your numbers will be entered. Right-click the
mouse on the selection, select Format Cells, then the number tab and select
Custom from the list. In the Type box, enter: #,##0 "WEEKS". This will now
display 20 WEEKS if the number 20 is entered into any of the cells in the
range selected (and any other number of course).

Ewan

"PierreL" wrote:

> I want the number 20 to display as
> 20 WEEKS
> I have tried (re Help)
> 0;;;" WEEKS"@
> and various combinations of ; spaces, the lot. Nothing works.
> Where is the error?
> Thanks,

Hello Ewan,
Did it and even copy/pasted yr string and I still get 0,WEEKS whatever the
number is entered.
I found that I could get to display WK 20 easily, probably due to this being
reserved for currency marking, no more than two digits though. So I will
stick to this.
Thanks anyway.
Pierre

"ewan7279" wrote:

> Hi Pierre,
>
> Select the column in which your numbers will be entered. Right-click the
> mouse on the selection, select Format Cells, then the number tab and select
> Custom from the list. In the Type box, enter: #,##0 "WEEKS". This will now
> display 20 WEEKS if the number 20 is entered into any of the cells in the
> range selected (and any other number of course).
>
> Ewan
>
> "PierreL" wrote:
>
> > I want the number 20 to display as
> > 20 WEEKS
> > I have tried (re Help)
> > 0;;;" WEEKS"@
> > and various combinations of ; spaces, the lot. Nothing works.
> > Where is the error?
> > Thanks,