excel doest not shows the number starting with 0..is there is any way to solve this.
 

i want to write codes in a cloumn A1..
all the codes begins with 0 and when i write any code which starts with
0..then code is not displayed with 0...suppose i want to write the
code......

0441
03241

but excel does not shows the zero .is theer any way to solve this
problem..


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=570062

excel doest not shows the number starting with 0..is there is any
 

Enter the code as '0441 and '03241. It will then show as 0441 and 03241

"naughtyboy" wrote:


i want to write codes in a cloumn A1..
all the codes begins with 0 and when i write any code which starts with
0..then code is not displayed with 0...suppose i want to write the
code......

0441
03241

but excel does not shows the zero .is theer any way to solve this
problem..


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=570062

excel doest not shows the number starting with 0..is there is any way to solve this.
 

If you format the cells as text, they will appear EXACTLY as you type
them..