On 20/02/18 11:44 AM, Ivo van Emmerik wrote:
1. Importing CSV
All the information is in the two documents
Delete the first two lines from the CSV file to get the columns correct
remember that each spreadsheet looks at the first line to
find what columns to use, then open it in Calc.
Because there are a lot of spaces in front of the values it is interpret
as text not as numbers, the way OpenOffice handles text
it puts the ` in front of the number.
If you remove all the spaces it will load correctly as numbers. To save
you a lot of time there is an option with importing CSV files
tick the Detect special numbers and it will handle the values as numbers
instead of text.
2) Posting questions on forum
Sorry I want to ask the forum a question! But I can not see a button
to start a new message, I logged in there is no clear indication where
to press, if I am blocked because I am new than tell me, this is very
frustrating!
Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
Windows 10
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
