Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

This is a bug. If field format is text, it should be sorted as text value.

As a workaround you could:

  1. Start writing the name with ', e.g '10<enter>, this makes sure the value is textual.

  2. Convert all the values to text with =A1&"", then copy the range and paste back as values (Edit → Paste special → Paste only values icon).