Formatting to thousands in a table

I have a table (not a pivot table) with large numbers in it e.g. 349652.59 which I have used formatting #,##0, to format to 350. However when I click in the cell the original number (349625.59) is vi...