SilentPirate007
New Member
- Joined
- Feb 7, 2010
- Messages
- 34
Hello,
I'm busy with a project and in excel I am trying to generate averages. But for the number "0", I need it to be replaced with "-" instead, but when I generate an average it disregards it. How could I get "-" to represent "0"?
This is a link to an example:
http://i893.photobucket.com/albums/ac137/SilentPirate007/excelproject.jpg
Thanks
I'm busy with a project and in excel I am trying to generate averages. But for the number "0", I need it to be replaced with "-" instead, but when I generate an average it disregards it. How could I get "-" to represent "0"?
This is a link to an example:
http://i893.photobucket.com/albums/ac137/SilentPirate007/excelproject.jpg
Thanks