You can format the cell beforehand as Text, or you could type an apostrophe
immediately before the number, e.g. '0400 will display as 0400.

Hope this helps.

Pete

"DeeKay" wrote in message
...
I want to display a four digit number which may or may not begin with zero,
i.e. (0215) (0050)