Forum Discussion
Can every type of text become an X?
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
2 Replies
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.
Using find and replace function
Give "?" in find, replace with "x".
Ask if you want anything than this.
