Concatenate

[b16]

I have the following issue:
In .xls I have the “column A” where users fill figures, usually having less than 9 characters. But, I need 9 characters length figures. To solve that I might use a second column, named “Column B”, where the figures from “Column A” wmay be increased by using the following forms:

“=Right(Concatenate(“000000000”;Column A);9)”

e.g.
Col A
Col B
123456
=Right(Concatenate(“000000000”;Column A);9)=000123456



But I’d really like to achieve the same results without the aid of “Column B” and said function, just using “Column A” and “Data validation”.

Does anyone know how to do it?


Thank you