text and number together in a cell

[saadferoze]

how can i have a number along with the text in the cells which can be calculated. suppose how can i write INR 500 and INR 300 in two different cells and still apply calculations on them. For that matter any text along with number


Regards

Saad

 

[Hui]

Saad

enter the numbers as 100 and 200

Goto Custom Number Format (Ctrl 1)

Enter "INR" #

as the custom number format


Doing this you can add the two cells together and get 300