Ask Your Question

downloaded calc files with ' in front of date information

asked 2017-04-07 02:32:56 +0100

wimpy88 gravatar image

date info displays '03/31/17 in downloaded calc file. All the other info may be cut & pasted into a spreadsheet without editing. Date requires retyping the data into the new spreadsheet.

Is there a simple way to eliminate the ' at the beginning of the date. I have experimented with the file dialogue box settings, but nothing changes the date info as downloaded.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-04-07 10:40:39 +0100

karolus gravatar image


Additional to @robleyd :

select the Column-header of Dates in the preview-window and change column-type m/d/y instead Standard

edit flag offensive delete link more

answered 2017-04-07 03:18:29 +0100

robleyd gravatar image

If you are importing via a .csv file, make sure Detect Special Numbers is selected in the Text Import dialog.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more

answered 2018-01-21 17:16:32 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Select the cells with the ' in front of the dates. Click on the TAB "data" and select "Text to Columns"

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-07 02:32:56 +0100

Seen: 121 times

Last updated: Jan 21 '18