Translations:MS Excel Tipps/14/en
Aus Wiki csv4you
Version vom 31. August 2016, 16:12 Uhr von Haemel (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „To import all columns correctly and to prevent automated reformatting by Excel, the entire data area shall be formatted as text: To do this, select the first c…“)
To import all columns correctly and to prevent automated reformatting by Excel, the entire data area shall be formatted as text: To do this, select the first column, press and hold the Shift key now pressed until you have added the remaining columns to the selection. As a result should the entire data area - as seen in the image - now be marked from left to right and appropriately highlighted black. Afterwards you choose as the data format of the columns the 'Text' option and quit the wizard with the 'Finish' button.
