Blank Cells

[daphoenix]

if there are blank cells in a range which i would specify i want to put in
the text "-". what kind of code would i use?

thanks

 

[Peo Sjoblom]

Select the range, press F5, click special and select blanks, press enter.
type
- and press ctrl + enter instead of enter

Note that if you have numbers in the other cells it is not a good design
using text as well


Regards,


Peo Sjoblom