neha has attended:
Excel Intermediate course
Excel is converting scores into different dates - how can I stop
I have an attachment to send through, which shows scores in column H. Some scores start with the word "Right eye" or "Left eye" therefore the scores that follow, are accurate.
Those scores that do not have the words Right or Left eye are causing excel to convert them into dates as shown below.
Where the score is documented as;
6/12 - excel is converting it to 06-Dec
6/18 - excel is converting it to June 18
6/24 - excel is converting it to June 24
Please see e-mailed attachment. Is there a way to tell excel these are not dates.
RE: excel is converting scores into different dates - how can I
Hi Neha,
You're right. Excel is viewing the numbers - 6/18 - as a date and is applying date formatting.
The formatting it has applied is: mmm-yy so you get Jun/18.
You can change the date format so you keep the numbers which were entered.
As you've done Excel Intermediate you should have covered this, it certainly should be in the manual if you can't remember all the steps.
Click in one of the problem cells, right click and choose format cells.
Select Custom from the panel on the left. From the panel on the right, click in the field under Type: and change the format to mm/yy. You can see this change in the Sample field at the top of the right hand panel.
If you apply this new format to the problem cells they should show as they were entered.
As you said the best solution is for the person who entered the data to include the text showing which eye is referred to.
Please let me know if you need more information.
Claire
