Hi all,
I have a column "U" with numbers. I had to change the format of cells from NUMBER to TEXT (because the next step is moving the data to Word) and apply comma style.
I managed to change the format to TEXT and then apply the comma style by using this code:
but...
Excel recognizes writing numbers as text as a mistake. I ignored this mistake and it looks fine, but it still cannot be imported to Word (all values are displayed as 0).
The entry now is justified (aligned) to left, while other columns are aligned to right and are displaying properly in Word.
How to convert it to `normal`TEXT format that will appear in a Word file? Thanks in advance for your help.
Bookmarks