Formula bar not showing all contents of the cell

[Tonoy Chakraborty]

The cells of an excel sheet exported from tally not displaying its contents fully on the formula bar which is why i'm unable o apply filter on those cells.E.g- 500.00 Dr is only showing 500.00 in formula bar and i need to filter aside the Dr's and Cr's separately.Please help..

 

[footoo]

Presumably the Dr and Cr displayed are the result of the cell formatting.

If so, assuming that the Dr values are positive and the Cr values are negative, to filter the Dr's :

• Select the column
• Click "Data" tab.
• Click "Filter" on the Ribbon.
• Click black triangle in filter cell
• Select "Number Filters"
• Click "Greater Than..."
• Type 0 (zero)
• Click OK