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/