if no data, then show empty cell

I'm using Excel 2003 and have a main workbook which stores the quotes, invoice, worksheet and contact details. In order to email only the invoice to a customer I have created another workbook which replicates whatever is shown in the open invoice tab of the main workbook. A macro from the main workbook then opens outlook.

I attach a sample of both for information.

My problem is this - You will note that on the email invoice that any entries where there is no cost in the main workbook, that it shows "£ -".

Can anyone tell me how to get it to show an empty cell if no value in the main workbook?

Any help or advice appreciated.

Try changing the custom number format to this:

_-"£"* #,##0.00_-;-"£"* #,##0.00_-;"";_-@_-

1st section if: postive values:   _-"£"* #,##0.00_-
2nd section if: negative values:  -"£"* #,##0.00_-
3rd section if: zero values:      ""
4th section if: text:            _-@_-

Does that help?