This OP is trying to understand why his (IMO erroneous) number format gives a different display in the spreadsheet than in the chart. I cannot really confirm his observations in my own version and I don't have 2013. Any takers?

http://www.excelforum.com/excel-char...ts-y-axis.html