Hi again Joel,

Do you have to change a setting to make the # invisible?
I can see it in front of my numbers.

Cheers
Tom


"Joel" wrote:

The # is invisible. I seem to be using the work visible/Invisible a lot
tonight.

"Tom" wrote:

Hi Joel,

Thanks for your reply - does that mean you have to see the # symbol or is
there a way of only seeing the zeros?

Cheers

Tom




"Joel" wrote:

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