In excel, when I insert figures, some are taken automatically in date format, some in numbers. Sometimes when I want to insert date it automatically converts in number format. How do I make it right?
I always format the column at the same time I am labeling or putting a title in the column. Just highlight the entire column and right click to format the date etc.
Answers & Comments
Verified answer
select the column, properties - and make it format as date or number.
I always format the column at the same time I am labeling or putting a title in the column. Just highlight the entire column and right click to format the date etc.
Format the cells before you insert the date.