| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get zero befor no. means eg 065 in excel
Hi,
I want to have zero befor any number in excel sheet but whenever I write automatically it disapperas(eg when I write 065 automaticaaly 0 disapperas and remains only 65)So if anyone know the way to solve this problem please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get zero befor no. means eg 065 in excel
To retain it as number, pre-format the col as Custom, Type: 000
If having it as text is okay, then enter it as text, either precede the entry with an apostrophe (type: '065 ), or pre-format the col as "Text" before entering -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "shiva" wrote: Hi, I want to have zero befor any number in excel sheet but whenever I write automatically it disapperas(eg when I write 065 automaticaaly 0 disapperas and remains only 65)So if anyone know the way to solve this problem please help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get zero befor no. means eg 065 in excel
Thanks.Your solution worked perfectly. "Max" wrote: To retain it as number, pre-format the col as Custom, Type: 000 If having it as text is okay, then enter it as text, either precede the entry with an apostrophe (type: '065 ), or pre-format the col as "Text" before entering -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "shiva" wrote: Hi, I want to have zero befor any number in excel sheet but whenever I write automatically it disapperas(eg when I write 065 automaticaaly 0 disapperas and remains only 65)So if anyone know the way to solve this problem please help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get zero befor no. means eg 065 in excel
Shiva, you're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "shiva" wrote in message ... Thanks. Your solution worked perfectly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| excel viewer | Setting up and Configuration of Excel | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Linear Mode
