inventory
 

can you make a sum a text insted of a number

inventory
 

EXCEL 2007

That depends upon what you want to do (you need to be more specific).

For example if cells G 5 to G 8 inclusive are filled with text then:-

=COUNTA(G5:G8) in cell G 9 returns the number 4.

If my comments have helped please hit Yes.




"Gary" wrote:

can you make a sum a text insted of a number

inventory
 

http://www.ozgrid.com/VBA/ValueToWords.htm


--
Regards
Dave Hawley
www.ozgrid.com
"Gary" wrote in message
...
can you make a sum a text insted of a number