S
Shehi_3
I have a table with two columns the first is a file number in the format of
(i.e.) 04-63, 04-64, etc. the second is text. I want to sort by the first
column and what happens is it puts for example 04-63 right before 04-632
instead of before 04-64. I have tried replacing the "-" with "." - no help -
I've tried sorting as text, numberic and also date with no luck. These
numbers are file numbers with the "04" being the year and the -# being the
next number in the sequence of files opened that year. As we close files we
enter the number in this table. I need them to read 04-1, 04-2, 04-3, etc.
through possibly 04-632 if we opened that many files that year. I can't get
them to sort by the first two numbers (99, 00, 01, 02, 03, 04, 05) and then
by the last set of numbers 1, 2, ...100,101,). Why is this so complicated?
Any suggestions?
Sandy
(i.e.) 04-63, 04-64, etc. the second is text. I want to sort by the first
column and what happens is it puts for example 04-63 right before 04-632
instead of before 04-64. I have tried replacing the "-" with "." - no help -
I've tried sorting as text, numberic and also date with no luck. These
numbers are file numbers with the "04" being the year and the -# being the
next number in the sequence of files opened that year. As we close files we
enter the number in this table. I need them to read 04-1, 04-2, 04-3, etc.
through possibly 04-632 if we opened that many files that year. I can't get
them to sort by the first two numbers (99, 00, 01, 02, 03, 04, 05) and then
by the last set of numbers 1, 2, ...100,101,). Why is this so complicated?
Any suggestions?
Sandy