| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The increase number of rows in Excel | Excel Discussion (Misc queries) | |||
| search for number in excel | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel random number | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
