This needs explaining, please
In column A you have 900 numbers
What does this mean: "All these data contain two function / and * "
Does it mean these numbers result from formulas rather than typed values?
What does this mean: "Out of these around 4-5 hundred rows consist decimals
values"
Does it mean some values are integer, others are real (in the mathematical
sense of having fractional parts)?

What do you want to sum?
To sum all negative numbers in A1:A900, =SUMIF(A1:A900,"0")

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Khalil" wrote in message
...
Hello Experts:

I have a data than contains more than 900 rows. All these data contain
two function / and *. Out of these around 4-5 hundred rows consist
decimals values.
I need to do two things with this data

1... Addition of round function to decimals values simultaneously
without using copy/Paste.

2...Addition of (- ) minus sign to rounded values at once without
using copy/Paste.

How couple of these things possible please advise


Thanks in advance

Khalil