Jul 18 2017 11:31 AM
Hello,
I have a question about Exel: can every type of text become an X?
When I put a text, any type, I would like to trasform it in an X, is it possible?
Thank you.
Regards.
Antonio
Jul 19 2017 08:05 AM
Using find and replace function
Give "?" in find, replace with "x".
Ask if you want anything than this.
Jul 19 2017 08:32 AM
Hi Antonio,
If you want to show the text as X you may apply custom format to your cells as
#,##0.00;-#,##0.00;0;X
selecting most suitable for numbers part.
If the goal is to change the content of the cell with the text on X when, as posted, to replace it or use some VBA to do that on the fly.