MS Excel number question
 

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.

MS Excel number question
 

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" wrote:

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.

MS Excel number question
 

Thanks that works great.

"akphidelt" wrote:

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" wrote:

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.