Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting characters consisting of numbers in VB
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting characters consisting of numbers in VB
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters | Excel Discussion (Misc queries) | |||
Counting characters | Excel Worksheet Functions | |||
Counting by numbers of Characters in a cell | Excel Discussion (Misc queries) | |||
Counting Characters | Excel Worksheet Functions | |||
Counting characters | Excel Discussion (Misc queries) |