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 |