bankerlady
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 73
I have a spreadsheet that has a column of dates formatted as 8/22/1977. I want to sort by the month so I tried using the =Left formula but it looks at the cell with the date as being text and returns a "2" as the 1st character. I have the column formatted as a date, but how do I get it to recognize the left number as what it really is instead of how it would format if it were text ?