G Guest Apr 17, 2006 #21 I do not believe so. How would you check that? Zack Barresse said: Do you have the format of the cells set to Text? Click to expand...
I do not believe so. How would you check that? Zack Barresse said: Do you have the format of the cells set to Text? Click to expand...
Z Zack Barresse Apr 17, 2006 #22 Select a cell, press Ctrl + 1, select the Number tab, it will be highlighted in the left listbox.
G Guest Apr 17, 2006 #23 what is highlighted is general not text. so, I guess the format of the cells is not set to Text. Thanks
what is highlighted is general not text. so, I guess the format of the cells is not set to Text. Thanks
Z Zack Barresse Apr 17, 2006 #24 You might then try .. If Clng(Cells(row, col).Value) <> 0 Then Cells(row, col).Value = 1 ... making use of the coerce/long function.
You might then try .. If Clng(Cells(row, col).Value) <> 0 Then Cells(row, col).Value = 1 ... making use of the coerce/long function.
