Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

"After an import of a CSV file, as there has been no way to define a column as "date/time" with a custom format during import, ..."
Very strange. Did you click on the column labels of the respective columns. Doing so you should have a choice in the 'Column type' field.

"After an import of a CSV file, as there has been no way to define a column as "date/time" with a custom format during import, ..."
Very strange. Did you click on the column labels of the respective columns. columns? Doing so you should have a choice in the 'Column type' field. field.

"After an import of a CSV file, as there has been no way to define a column as "date/time" with a custom format during import, ..."
Very strange. If you got the standard import dialog for csv: Did you click on the column labels of the respective columns? Doing so you should have a choice in the 'Column type' field.field.

A very similar dialog will open if you use the 'Text to columns...' tool for one column at a time.

(Editing with respect to the comments by the OQ:)
Most likely the apostrophe is not part of the text contained in the cell, but an indicator shown in the formula bar or when the cell is entered for editing to tell that something recognizeable as some kind of numeric entry was treated as text instead. Therefore the RegEx 'F&R' does not apply.
(End Editing)

"After an import of a CSV file, as there has been no way to define a column as "date/time" with a custom format during import, ..."
Very strange. If you got the standard import dialog for csv: Did you click on the column labels of the respective columns? Doing so you should have a choice in the 'Column type' field.

A very similar dialog will open if you use the 'Text to columns...' tool for one column at a time.

(Editing with respect to the comments by the OQ:)
Most likely the apostrophe is not part of the text contained in the cell, but an indicator shown in the formula bar or when the cell is entered for editing to tell that something recognizeable as some kind of numeric entry was treated as text instead. Therefore the RegEx 'F&R' does not apply.
(End Editing)

@michaelof: "After an import of a CSV file, as there has been no way to define a column as "date/time" 'date/time' with a custom format during import, ..."

Very strange. If you got the standard import dialog for csv: Did you click on the column labels of the respective columns? Doing so you should have a choice in the 'Column type' field.

A very similar dialog will open if you use the 'Text to columns...' tool for one column at a time.