I haven't encountered this but have you tried select the cell, going to the home ribbon tab I think, then clicking normal. Then adding the number formating you want