Hi
I have a column set as text and use numbers in it like 0001, 1100 etc.
If i edit these numbers they get the little green triangle in the corner of the cell that warns me that it is a number in a text cell. Now when I sort on this column these numbers sort separately at the bottom of my sort. How can I fix this so all number are seen the same and the formatting stays as text so I can have numbers with zeros in the front.
Bookmarks