Calculate cell if number [not text]

I need to carry out some calculations on over 50,000 cells. 'Each record' consists of a unique reference, followed by 10 cells [columns] which either contain numbers or text. I wish to change only the cells containing numbers. Is there a non VBA way to do this?
Your help is appreciated. My thanks in advance.
David

Originally Posted by davidthegolfer

I need to carry out some calculations on over 50,000 cells. 'Each record' consists of a unique reference, followed by 10 cells [columns] which either contain numbers or text. I wish to change only the cells containing numbers. Is there a non VBA way to do this?
Your help is appreciated. My thanks in advance.
David

Hi David,
how to you wish to " change " those cells?
Could you post an example of what you are trynig to do?

I hope this example helps

Ref123 N/A N/A 1798 1690 1540 1300 1109 999 875 779

5%


Result for record + 5%

Ref123 N/A N/A 1888 1775 etc etc etc ...... ..... .....


I need a formula that will transfer text to the new location of if a number will carry out a percentage uplift. Say 5%. This will in facr be a lookup from a table.

I hope this helps.
My thanks
David

To answer one part of your question, raising numbers with a percenatge can be done as follows :
in an empty cell input how much you want the values increased ( say 1.05)
Copy this cell
Select the rows for which the values must be raised
Right-Click
Select " Paste Special"
Check Multiply
OK
All numbers are now increased by 5%
( adapt formatting to your needs)

HTH

Thank you. I use quite complicated uplift tables etc. to do this. My problem is that there are about 2,000 cells containing N/A or Refer throughout the database. Applying the calculation to EVERY cell means that I corrupt the text cells and have to manually lookup and write over them.

I was hoping to construct a test to each cell before I apply the % uplift.

If text , write text to new cell. If number, apply %, write new value to the new cell.... kind of thing.

Thanks

David