Hi go to format cells, custom and use #,##? and it will get rid ofthe 0's and leave the rest of the number.