Hiding N/A (Formula value) for printing purposes

[North for Short]

I have searched the site and I cannot find what I am after. I have a sheet which use for authorising overtime timesheets. I have written the formulas and now I want to hide them. In excel 1997-2003 version, I could do this but I have been away from this type of work for at least a good 5 years. (Even this site has evolved since I last used it.).

[TABLE="width: 579"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Mickey mouse[/TD]
[TD] [/TD]
[TD="colspan: 2"]12345[/TD]
[TD] [/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD="align: right"]10:00[/TD]
[TD] [/TD]
[TD="align: right"]12:00[/TD]
[TD] [/TD]
[TD="align: right"]02:00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD="colspan: 2"]#N/A[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 2"]Don Duck[/TD]
[TD] [/TD]
[TD="colspan: 2"]#N/A[/TD]
[TD] [/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD="align: right"]08:00[/TD]
[TD] [/TD]
[TD="align: right"]13:00[/TD]
[TD] [/TD]
[TD="align: right"]05:00[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]


Where I have put data in, that's fine but where there is no data, I want to show a blank cell. I have searched options in excel but I cannot find anything. I know it is a pretty simple operation but I have spent too long now trying to find it.
Can someone help me out of my misery please?

 

[Norie]

If the #N/A! are the result of formulas you could try this.

=IFERROR(yourformula, "")

 

[SpillerBD]

In Page Setup/ Sheet tab. "Cell errors as:" = change to a more appropriate option.

 

[North for Short]

In Page Setup/ Sheet tab. "Cell errors as:" = change to a more appropriate option.

Great. Works a treat and fast response too. Now I will be able to sleep tonight. Thanks everyone else too