V
vwdrv1
5 column spreadsheet...Want to sort by col A while keeping B-E attached to
original col A...
I originally set this up a few years ago, and thought I was doing the right
thing when formatting each cell....
Col A=5 digit number; Col B= 5 digit number with a hyphen; Col C= Date
(month & year-ie 8/05); Col D= Date (month, day, year-ie 9/01/05) Col
D=occasional special note/mostly blank)
I currently have 126 rows of info.....When I "sort" , the list sorts
correctly down through row #89......Row #90 starts a new sequence down
through Row #126....
I've tried changing cell format .....That seems to work --but---when I
change all columns to a Text Format, the date in column D changes to a random
5 digit number...
I'm at a loss on what to do....Please help....Thanx
original col A...
I originally set this up a few years ago, and thought I was doing the right
thing when formatting each cell....
Col A=5 digit number; Col B= 5 digit number with a hyphen; Col C= Date
(month & year-ie 8/05); Col D= Date (month, day, year-ie 9/01/05) Col
D=occasional special note/mostly blank)
I currently have 126 rows of info.....When I "sort" , the list sorts
correctly down through row #89......Row #90 starts a new sequence down
through Row #126....
I've tried changing cell format .....That seems to work --but---when I
change all columns to a Text Format, the date in column D changes to a random
5 digit number...
I'm at a loss on what to do....Please help....Thanx