forced sorting question

[Maria Sosnowski]

Hi there,

 

I’m trying to force sort months to be in order chronologically rather than alphabetically.  I inserted a hidden number in front of each one, so 1 for January and 12 for December.  I have “sort Arabic numbers” checked under Options>Index. 

 

The months sort perfectly up until September.  But October, November, and December are sorting before everything else.  Okay, I thought I would try making October 90 because it seems that would move it after September.  It does move it away from the front of the list, but still puts it before September.

 

What am I missing?  I feel like there is some obvious thing I’m just not seeing. 

 

Maria

[Theresa Duran]

Maria, I just tried it using two-digit hidden numbers (01January, 02February, etc.), and it worked fine.

 

Theresa

--
You received this message because you are subscribed to the Google Groups "SKYIndexUsers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to skyindexuser...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/skyindexusers/0ce701d7bbd1%24307ebc10%24917c3430%24%40index-plus.com.

[mjhw...@gmail.com]

Try this: In the Sorting dialogue (Options > Index > Sorting), under "Date sorting" check the box marked "Sort Dates". (Find full instructions in the User's Guide in the "Sorting" section of the "Index Options" chapter.)

Michael

[Maria Sosnowski]

Thanks for another idea!  I already changed the numbers to start with a zero and it sorted beautifully, but I’ll keep this in mind for the future.

 

Maria

--

You received this message because you are subscribed to the Google Groups "SKYIndexUsers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to skyindexuser...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/skyindexusers/b2e6d258-c06e-4747-ab22-eb9f9052ec99n%40googlegroups.com.

[Maria Sosnowski]

Thanks for the idea.  Someone else suggested that off list too.  I didn’t even think to try that.  I knew someone on the list would know!

 

Maria

 

 

From: skyind...@googlegroups.com <skyind...@googlegroups.com> On Behalf Of Theresa Duran
Sent: Thursday, October 7, 2021 4:35 PM
To: 'SKYIndexUsers' <skyind...@googlegroups.com>

To view this discussion on the web visit https://groups.google.com/d/msgid/skyindexusers/001301d7bbd3%24ed528220%24c7f78660%24%40pacbell.net.

[Barry.c...@indexbase.co.uk]

Within text you’d normally expect a text sort.

Use 01, 02, 03 etc.

Always use a consistent number of characters in the number, then it will work.

For instance if you have many subheadings you want to force sort then use

0010

0020

0030

0040

Etc. By incrementing in 10’s you can slip others in later.

Barry Campbell

www.indexbase.co.uk

IndexConvert

IndexExploit

[Maria Sosnowski]

Leaving space to add others later is a clever idea, thank you.

 

Maria

 

 

From: skyind...@googlegroups.com <skyind...@googlegroups.com> On Behalf Of Barry.c...@indexbase.co.uk

Sent: Thursday, October 7, 2021 6:37 PM
To: SKYIndexUsers <skyind...@googlegroups.com>

Subject: [SKYIndexUsers] Re: forced sorting question

 

Within text you’d normally expect a text sort.

--

You received this message because you are subscribed to the Google Groups "SKYIndexUsers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to skyindexuser...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/skyindexusers/c355bbaa-fe22-4e7c-8e53-22f84f54b5d8n%40googlegroups.com.

[rm.briggs]

Two or more digits are also easier to 'select' with a mouse to use Format and Hide, for old fogeys like me anyway.

Robin