Forcing Excel to Sort Cells as Text
if there is a simple way to make Excel sort all the part numbers as text.
The easiest way is to format the cells as text—This must be done before you enter information into the cells.
If you try to format as text a cell containing a number, that doesn't change the number to text. However, if the cell is formatted as text before you enter the number, then the number is treated as text upon entry.
The solution is to re-enter all your numbers after you format your cells as text. This, of course, could be a major chore when you may be dealing with hundreds or thousands of part numbers. Instead, you could try the following general steps in which we assume the part numbers are in column A
In this case you could, if desired, use a macro to make sure your part numbers are always formatted as text. The following is just a short one that will work great:
Copy the formula down as many cells as necessary
Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London
No comments:
Post a Comment