chandra.asodi
New Member
HI,
I daily deal with multiple spread sheets related billing. My question is
I have entered a different values from A1 to A10 and summed up the total. E.g 1,2,3,4,5,6,7,8,9,10 and the total is 55. I have selected cell no A5 which is a value of 5. I formatted the cell-Selected "Number" "Custom" type as ,,,. and the value in A5 visilbe as ",".
The visible no from A1 to A10 as 1,2,3,4,,,6,7,8,9,10 and the total as 55. It is supposed to 50 only if i check with a hard copy of the same with a calculator
My question is "Is there any fromula to find the cell (A5)with the this type of format.
Thanks in advance
I daily deal with multiple spread sheets related billing. My question is
I have entered a different values from A1 to A10 and summed up the total. E.g 1,2,3,4,5,6,7,8,9,10 and the total is 55. I have selected cell no A5 which is a value of 5. I formatted the cell-Selected "Number" "Custom" type as ,,,. and the value in A5 visilbe as ",".
The visible no from A1 to A10 as 1,2,3,4,,,6,7,8,9,10 and the total as 55. It is supposed to 50 only if i check with a hard copy of the same with a calculator
My question is "Is there any fromula to find the cell (A5)with the this type of format.
Thanks in advance