How can i delete zero in start of value by using formula i.e (0000010 in to 10)
C capreecorn Apr 3, 2009 #1 How can i delete zero in start of value by using formula i.e (0000010 in to 10)
D DILipandey Apr 3, 2009 #3 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.) [email protected] [email protected] New Delhi, India
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.) [email protected] [email protected] New Delhi, India
