Greg Maxey,
Unless yesterday when I've used my example table of 10 Columns in total, 5 of numbers and 5 empty ones besides them, I've only tested the $ and assumed it worked for the %.


Now all $ works A1, it doesn't work for the %.


The only difference is maybe the position of the searched value. When I use the English Tables that I must convert to French, the position of the $ is in front of the numbers, which needs to be moved to the next cell. & The %, is at the end regardless French of English, which needs to be moved to the next cell.


Is it fixable? It was working so great. I've almost showed people at work.


Any advice?


Cendrinne