| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove zero
How can i delete zero in start of value by using formula i.e (0000010 in to 10)
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove zero
Please don't multi post, you have an answer in programming.
"capreecorn" wrote: How can i delete zero in start of value by using formula i.e (0000010 in to 10) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove zero
Hi capreecorn,
Supposing you have the data in Cell A1, use following formula:- =VALUE(A1) It will eliminate the starting zeros. Thanks. -- Click on Yes, if it is useful. Thanks & Best Regards, Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "capreecorn" wrote: How can i delete zero in start of value by using formula i.e (0000010 in to 10) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove of ' | Excel Discussion (Misc queries) | |||
| remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
| How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
| Remove the #DIV/0! | Excel Worksheet Functions | |||
| REMOVE #N/A | Excel Worksheet Functions | |||
Hybrid Mode
