Or right click cell, click format, change to number format.

Odd that it's making it 20.5 when you're typing in 2050

Changing to text format will give you an annoying red mark in corner and ask if u want to convert to a number.

If text does the job though that's cool. I work on Excel evey day and things like that bug you after a while lol

Posted By: CityForLife, Feb 23, 18:47:09