Displaying zero as - in excel

I am doing a spreadsheet in excel for a client who likes zero to be displayed as a dash rather than blank or zero. I can't seem to get it to display a dash and there is nothing in "help" that I can find. Any ideas?
Nicola Stone

Comments
There are 9 comments. Login or register to view them.

Tony

neileg |

I forgot... suggestion

AnonymousUser |

A techies answer

AnonymousUser |

How about this

neileg |

Try this

AnonymousUser |

Success!

nicstone |

Dashes as zeros

birdman |
birdman's picture

I forgot...

nicstone |

Use Accounting number format

Julian Tomsett |