MS Excel number question

[Redsphynx]

I want to display 0100 or 02576 but when it shows 100 or 2576. Is there a
setting I can change? I use Microsoft Excel 2003.

 

[akphidelt]

The only way I know how to do that is to turn it in to text...

so put a ' in front of it

So the cell would look like

'0100

But the ' will not show

 

[Redsphynx]

Thanks that works great.

The only way I know how to do that is to turn it in to text...

so put a ' in front of it

So the cell would look like

'0100

But the ' will not show