Difference between revisions of "Excel"
From Server Knowledge Base
Jump to navigationJump to searchRootadminacc (talk | contribs) (Created page with "== Converting columns == If you load a CSV sheet and they are showing data (columns/rows) wrong use the Data > From Text (Import function). A common example is when fraction...") |
Rootadminacc (talk | contribs) m |
||
| Line 5: | Line 5: | ||
A common example is when fractions get converted to dates. | A common example is when fractions get converted to dates. | ||
- Click Next | <pre>- Click Next | ||
- Untick Tab | - Untick Tab | ||
- Tick Comma | - Tick Comma | ||
| Line 11: | Line 11: | ||
- Select the Text radio button instead of the General radio button | - Select the Text radio button instead of the General radio button | ||
- Next/Finish | - Next/Finish | ||
- Next/Finish | - Next/Finish</pre> | ||
Another common example is when dates get converted to numbers. In this case: | Another common example is when dates get converted to numbers. In this case: | ||
- Select the whole Column | <pre>- Select the whole Column | ||
- Right click and select Format Cells | - Right click and select Format Cells | ||
- Select the Number tab | - Select the Number tab | ||
| Line 22: | Line 22: | ||
- Enter the Date you want e.g. dd/mm/yyyy hh:ss:mm dd/mm/yyyy hh:mm:ss | - Enter the Date you want e.g. dd/mm/yyyy hh:ss:mm dd/mm/yyyy hh:mm:ss | ||
- Next/Finish | - Next/Finish | ||
- Next/Finish | - Next/Finish</pre> | ||
Latest revision as of 18:35, 4 January 2015
Converting columns
If you load a CSV sheet and they are showing data (columns/rows) wrong use the Data > From Text (Import function).
A common example is when fractions get converted to dates.
- Click Next - Untick Tab - Tick Comma - Select the Column you want - Select the Text radio button instead of the General radio button - Next/Finish - Next/Finish
Another common example is when dates get converted to numbers. In this case:
- Select the whole Column - Right click and select Format Cells - Select the Number tab - Select the Category: Number - Then Select Custom - Enter the Date you want e.g. dd/mm/yyyy hh:ss:mm dd/mm/yyyy hh:mm:ss - Next/Finish - Next/Finish
