Thread: How to hide day
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
sureshift sureshift is offline
external usenet poster
 
Posts: 2
Default How to hide day

Thanks for your help it worked..
"sureshift" wrote in message
...
I have this equation.
=Text(f1,"DDDD") Which comes out as 3/1/08 Thursday.
How do I get it to come up blank till I put in a date.
At the moment it comes up like this.
3/1/08 Thursday
Friday
Friday
Thanks in advance Larry