CELL FORMAT - IF CONDITION

[Suresh Kusunuri]

My Cell Format is ""0.00" Cr". But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other programme. Now, I want to get the value from this cell to another cell based on “Cr” by using IF condition. But “Cr” is not appeared in the cell for applying formula. Can anybody help me?

Thanks
Suresh

 

[Fluff]

@loginid
I suspect you missed post#13

"Dr" stands for positive and "Cr" stands for Negative