Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
#3
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
custom list with accounting format | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Format text across cells | New Users to Excel | |||
How to write a "Text" or date custom format | Excel Worksheet Functions |