| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
It display's Sat
Hello from Steved
What is required please to the below to have the "cell blank" as at the moment it displays Sat. =TEXT(H41,"ddd") Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
It display's Sat
Try
=IF(H41="","",TEXT(H41,"ddd")) instead of =TEXT(H41,"ddd") "Steved" wrote: Hello from Steved What is required please to the below to have the "cell blank" as at the moment it displays Sat. =TEXT(H41,"ddd") Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
It display's Sat
try
=IF(LEN(TRIM(H41))<1,"",TEXT(H41,"ddd")) -- Don Guillett Microsoft MVP Excel SalesAid Software "Steved" wrote in message ... Hello from Steved What is required please to the below to have the "cell blank" as at the moment it displays Sat. =TEXT(H41,"ddd") Thankyou. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
It display's Sat
Thankyou.
"Don Guillett" wrote: try =IF(LEN(TRIM(H41))<1,"",TEXT(H41,"ddd")) -- Don Guillett Microsoft MVP Excel SalesAid Software "Steved" wrote in message ... Hello from Steved What is required please to the below to have the "cell blank" as at the moment it displays Sat. =TEXT(H41,"ddd") Thankyou. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
It display's Sat
Thankyou
"Sheeloo" wrote: Try =IF(H41="","",TEXT(H41,"ddd")) instead of =TEXT(H41,"ddd") "Steved" wrote: Hello from Steved What is required please to the below to have the "cell blank" as at the moment it displays Sat. =TEXT(H41,"ddd") Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook display's title bar and right scroll bar outside Excel wi | Excel Discussion (Misc queries) | |||
Linear Mode
