The issue is as follows:
I am entering dates in column A. In the subsequent columns B, C,...etc., I enter numbers.
I enter the date in cell A1 (formatted as a custom date format), hit tab to move to the next cell B1 (formatted as general), enter the number and hit tab again. Lo! the number in B1 becomes a date. The same happens to C1 also.
Every time I have to manually change the format of the cell to number.
I tried to correct this by selecting column B, C,... and format as general. However, the problem recurs when I enter the data for the next row.
Really frustrating!
I would be extremely thankful to anybody who can help me out!
Bookmarks