Translations:MS Excel Tipps/18/en

The data will now be displayed as text - at first no calculations can be done. Now replace all Dots (.) by Comma (,) - or vice versa - with the 'Search and Replace' button. Then select all columns that contain numbers, and format the cells. You do this in the 'Numbers' category where you select 'Standard'.