Hey guys!
This will be my first post ever in this forum.
I have two questions to ask:
1) When I use the Group function under the "Data" tab, it starts to create blank columns which makes my navigation bar smaller every time I scroll to the right. For example, once the Group function is in effect, whenever I want to scroll to the far right side of my spreadsheet, it will create random blank columns that does NOT disappear when I scroll back to left (usually when I use the keyboard to go to the right, it creates new blank columns but disappears when you scroll back to the left right?). How do you prevent this from happening? Having more and more columns will make the navigation through the spreadsheet difficult.
2) If I have a cell called January, how do you go about converting it into a number (like, 01?) I tried TEXT, DATEVALUE, MONTH, but not working properly :S
Thanks in advance :D
Bookmarks