Numeric values not being recognize on password

[stoey]

hi,

yesterday shg was able to help me solve this worksheet program. The problem I currently have is all numeric values only are not being recognized on my password column. I have tried changing the cell formats but still problem still there. The program work if an alphanumeric value is declared as password. However if you simply indicate plain numeric values only as password, it returns incorrect values, it like it doesn;t recognize all numeric values. Also how can I make 0000 as a declared password? when I place 0000 on my password column, only one zero value is being displayed instead of four another thing if I happen to place 0123 only 123 is being displayed. Any one please help? I have attached my workbook which has the problem

Thanks,
Stoey

[JBeaucaire]

Use '0000 to enter the digits as text. See if that solves the recognition issue, too.

EDIT: It tried that on your sheet and it works great. Use the apostrophe to preface numeric strings to enter them as text.

[stoey]

hi JB,

I tried that actually before and it did work, but my apprehension is that when I declare it as text, the numeric values on password column has this green mark inside the cell above it. When I click that green mark, it displays an exclamation mark with the following choices like Stored as Text, convert to number etc... will this not affect the flow of the program as it is being use? Will it not create a conflict?

Thanks,

Stoey

[JBeaucaire]

No. That's just Excel trying to warn you if you enter a cell format different from the ones nearby. I wouldn't fret it if you do it on purpose.

If it really bugs you, you can enter ALL the passwords with the apostrophe leader.

[stoey]

got it...thanks jb...