Ravi,
Select the range; press ctrl+H and key in 0 in "Find what" Bar and blank in
"Replace with" Bar. This will give you the required result.
On Sat, Jul 25, 2009 at 2:56 PM, Ravi Megharaj wrote:
> Hi Friends,
>
> Can someone provide me formula or code to remove leading zeros from a set
> of
Suresh
Key in this formula, this will serve. Unable to upload xls from my end.
Please read alphabets as columns. *Sheet 1* ** ** *C* *D* *E* *F* Name
Data Date No. Su 12 01/01/1999 123 gu 22 02/02/1999 124 gg 33 03/03/2000 125
*Sheet 2* ** ** ** ** *C* *D* *E* *F* *G* *H* Name Data Date
