I have a long list of numbers formatted as "General" and some of them have a decimal and the decimal does not display in this format. I want to change formatting to “Text” but when I do the decimal still does not display until I double click in the cell. How can I change a long list of numbers with decimals to “Text” format and have the decimal display without having to double click each cell? This is very time consuming.
Bookmarks