View Single Post
  #1   Report Post  
Jane Martin
 
Posts: n/a
Default How do I sort hexidecimal numbers in an excel spreadsheet?

When I attempt to sort hex numbers in a spreadsheet I get incorrect results.
The cells are formatted as text (else the leading 0 would be dropped). I
would like sort results to run from 0000 - ffff. any ideas?