Thread: formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joe@malvern[_2_] joe@malvern[_2_] is offline
external usenet poster
 
Posts: 20
Default formatting

I have formatted a data entry column for dates as follows:
Category=date
type=03/14/01

how can I format the cell to remain blank after using an IF function?
currently it returns 01/00/00

thanks