We have a dataset, contains numeric figures are custom formatted as Debit "Dr" and Credit "Cr". We want to extract/ filter that numbers as Dr or Cr. Kindly help us.
maniknandi
Format cells C5:C12 as Number with two decimal places.
or
If You need to values to F-column then
Cell F5 =C5 and copy down.
Format cells C5:C12 as Number with two decimal places.