Hello Dries
Thank you for your reply. Yes i am aware of the ascii code but it doesnt seem to apply when some cells contain numbers rather than text. For example # comes before "1" in the table but it sorts after numbers. I want something i can put in a cell which will sort before any number. I suspect there isnt anything. Maybe it might work if i can convert all the relevant numbers i have entered to text but im still looking for a way to do that. Format>cells>numbers and selecting text doesnt do it, at least not in 5.2.2.2 under windows7. The format *appears* to change in that the numbers become left justified like strings but istext (cell) still returns false....
/G.
![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}