Excel - Revision history

Rootadminacc at 18:35, 4 January 2015

2015-01-04T18:35:30Z

← Older revision		Revision as of 19:35, 4 January 2015
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>

Rootadminacc: 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..."

2015-01-04T18:35:08Z

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..."

New page

== 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