You need to format cells using Format - Numbers - Special

Use something like this to make 4 digits
#0000

"Tom" wrote:

Hi,
I have a friend who wishes to display zeros in front of other numbers and
the Excel program keeps disappearing them. I tried to modify the
Tools/Options/View/Zero Values but whether this box is checked or not doesn't
seem to make any difference.
Any ideas would be greatly appreciated.
Tom