Ask Your Question

How do I convert "Text Numbers" created by opening a CSV Currency Column?

asked 2017-01-04 21:36:30 +0200

teardropvideo gravatar image

Currency or Numbers end up with the hidden "'" before the number. Formatting isn't possible until these cells become numbers.

edit retag flag offensive close merge delete


Are you selecting the checkbox for Detect special numbers on the Text import dialog box? Also, if the fields in the csv file are delimited, try unchecking Quoted field as text

robleyd gravatar imagerobleyd ( 2017-01-05 03:27:33 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-01-05 01:24:52 +0200

m.a.riosv gravatar image

Could work Menu/Data/Text to columns

edit flag offensive delete link more

answered 2017-01-06 20:46:16 +0200

teardropvideo gravatar image

Menu/Data/Text to Column , but you have to select "Text Delimiter". Thanks.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-04 21:36:30 +0200

Seen: 1,603 times

Last updated: Jan 06 '17