Counting characters consisting of numbers in VB

[svai]

Hi!

I have a problem regarding cells(x, y).characters.count i Visual Basic. This
method won't work when the cell value is a number. I've tried to format the
cells as Text in Cell properties, but that doesn't solve the problem. What's
the easiest way around the problem? Without having to enter each cell and put
an apostrophe before the number. Every cell value is an integer.

Thanks
Stefan

[mcg]

svai napisal(a):
> Hi!
>
> I have a problem regarding cells(x, y).characters.count i Visual Basic. This
> method won't work when the cell value is a number. I've tried to format the
> cells as Text in Cell properties, but that doesn't solve the problem. What's
> the easiest way around the problem? Without having to enter each cell and put
> an apostrophe before the number. Every cell value is an integer.
>
> Thanks
> Stefan
try m = Len(Selection)
mcg