Use a custom number format like this

dddd;;-

the format is

positive number; negative number; zero; text

--
Regards,
Tom Ogilvy


"goss " wrote in message
...
Thanks Tom
Guess I should look for the easiest answer first
Of course, your solution worked

How could I change this format after input?
Ex: C1 awaits user input for a date
B1 (=C1) is formatted dddd
Currently displays Saturday which must be 0

I'd like to display "-" as in zero for accounting format if C=0
Once user enters date in C1 remaining dates in Col C should fill and
days in col B should appear


---
Message posted from http://www.ExcelForum.com/