R Redsphynx Feb 7, 2008 #1 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.
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.
A akphidelt Feb 7, 2008 #2 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
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
R Redsphynx Feb 7, 2008 #3 Thanks that works great. akphidelt said: 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 Click to expand...
Thanks that works great. akphidelt said: 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 Click to expand...
