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
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.