Ask Your Question

T-buch's profile - activity

2018-04-26 13:11:41 +0100 received badge  Notable Question (source)
2018-04-25 12:35:08 +0100 edited question (SOLVED) Convert text (2. October 1928) to data

Convert text (2. October 1928) to data I got two columns: 1st column contains a start-date and second column contains a

2018-04-25 12:35:08 +0100 received badge  Editor (source)
2018-04-25 12:33:55 +0100 received badge  Popular Question (source)
2018-04-25 11:50:19 +0100 marked best answer (SOLVED) Convert text (2. October 1928) to data

I got two columns: 1st column contains a start-date and second column contains an end-date of a period. in the third column I would like to calculate the period in months.

The dates in the first and second columns are plain text such as 1st column: "2. October 1928" and second column: "7. June 1930" (Note the sentence).

2018-04-25 11:50:09 +0100 commented answer (SOLVED) Convert text (2. October 1928) to data

I found out that I also have to select the column in the dialog box (even though I already did that in the first place i

2018-04-25 10:54:14 +0100 commented answer (SOLVED) Convert text (2. October 1928) to data

Thanks but for me - in my calc, the "column type" is greyed out/ not available

2018-04-25 10:54:14 +0100 received badge  Commentator
2018-04-25 10:40:43 +0100 edited answer (SOLVED) Convert text (2. October 1928) to data

for me in my calc, the "column type" is greyed out/ not available

2018-04-25 10:40:26 +0100 answered a question (SOLVED) Convert text (2. October 1928) to data

for me i my calc, the "column type" is greyed out/ not available

2018-04-25 10:31:01 +0100 commented question (SOLVED) Convert text (2. October 1928) to data

Thanks but I onlu got "#VALUE!"

2018-04-25 09:11:35 +0100 asked a question (SOLVED) Convert text (2. October 1928) to data

Convert text (2. October 1928) to data I got two columns: 1st column contains a start-date and second column contains a

2018-04-25 09:11:33 +0100 asked a question Convert text (2. October 1928) to data

Convert text (2. October 1928) to data I got two columns: 1st column contains a start-date and second column contains a

2018-02-05 23:16:47 +0100 received badge  Famous Question (source)
2018-02-05 23:16:47 +0100 received badge  Notable Question (source)
2018-01-19 05:43:46 +0100 received badge  Famous Question (source)
2017-08-03 11:53:05 +0100 marked best answer Can calc. create a rectangle based on cell data?

I have made a spreadsheet that calculates the height and length of a rectangle

Can calc. create a rectangle based on these two calculations/cells?

2017-08-03 11:52:52 +0100 commented answer Can calc. create a rectangle based on cell data?

Yes you are right @Ratslinger and thanks - now J Can the macro be set for the second sheet?

2017-08-02 17:31:33 +0100 commented answer Can calc. create a rectangle based on cell data?

Okay - you are the patience type J Visible: True SizeProtect: False MoveProtect: False FillColor: 10079487 LineColor: 0

2017-08-02 06:43:52 +0100 commented answer Can calc. create a rectangle based on cell data?

This is what I am doing https://youtu.be/52fgfA85zBQ

2017-08-01 20:39:44 +0100 commented answer Can calc. create a rectangle based on cell data?

Chance the values (that make sense) - but nothing happen Just to be absolutely sure - It is supposed that the rectangle

2017-08-01 20:35:58 +0100 commented answer Can calc. create a rectangle based on cell data?

Chance the values (that make sense) - but nothing happen Just to be absolutely sure - It is supposed that the rectangle

2017-08-01 19:49:27 +0100 commented answer Can calc. create a rectangle based on cell data?

https://image.ibb.co/cX80Pk/Sk_rmbillede_PC_468.jpg https://image.ibb.co/g8QKH5/Sk_rmbillede_PC_467.jpg

2017-08-01 19:39:15 +0100 commented answer Can calc. create a rectangle based on cell data?

First of all i got no drawings (but also no errors) 4cm from the top and 4cm from the left side I am looking at the shee

2017-08-01 19:05:22 +0100 received badge  Notable Question (source)
2017-08-01 18:48:32 +0100 commented answer Can calc. create a rectangle based on cell data?

Okay but where do the function draw the rectangle?

2017-08-01 16:54:00 +0100 answered a question Can calc. create a rectangle based on cell data?

Okay thanks - but I had never done a macro before, so I am afraid for I have to ask you some more questions Where do I

2017-08-01 16:05:28 +0100 received badge  Popular Question (source)
2017-08-01 12:48:57 +0100 asked a question Can calc. create a rectangle based on cell data?

Can calc. create a rectangle based on cell data? I have made a spreadsheet that calculates the height and length of a re

2016-11-20 13:05:42 +0100 received badge  Popular Question (source)
2016-11-20 11:40:27 +0100 received badge  Scholar (source)
2016-11-20 11:40:21 +0100 commented answer Convert Text to table

Thanks a lot

2016-11-20 07:17:52 +0100 asked a question Convert Text to table

Pease see the picture Anyone have an Idea of how to get from the sample text to this table:

image description

a way might be to use the "text to columns" function in Calc as a middle way - But perhaps there is a smarter way to do it?