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

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


"daphoenix" <daphoenix@discussions.microsoft.com> wrote in message
news:FEE7427B-C73F-4F6D-970B-8D438C42661A@microsoft.com...
> 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