Forum Discussion

Copper Contributor

Feb 25, 2022

Excel Numbering sequence issue

I am trying to number a spreadsheet with the following format (1.0, 1.1, 1.2, 1.3). However when I do a sort by it jumps my numbers around. For example if I use 1.0, 1.1, 1.2, 1.3 etc. when I sort it...

excel

mtarler

Silver Contributor

Feb 25, 2022

ok maybe your space is different than mine. lol.
by any chance is your 1.10 entered as a number while the 1. 0 is text?
try entering '1.10 that ' will force it to be text.

Soraiya

Copper Contributor

Feb 25, 2022

mtarler

Thank you! That did it! Woohoo! I appreciate all your help! Thank goodness I can now finish my spreadsheets!