Bug 91399

Summary:	Please add a "convert to number" menu option for cells starting with an apostrophe
Product:	LibreOffice	Reporter:	S. <sb56637>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	enhancement	CC:	cno
Priority:	medium
Version:	unspecified
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description S. 2015-05-19 21:52:10 UTC

Hello,

Users often import data from CSV files and the like, and numbers sometimes start with an apostrophe so that they are handled as strings, for example:
'123
'456
'789

LibreOffice users frequently want to convert those items into numbers, but there is no easy, intuitive way to do so:
- http://en.libreofficeforum.org/node/484
- https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=49046
- https://jaisejames.wordpress.com/2013/01/02/remove-apostrophe-used-for-text-formatted-number-in-libreoffice/

In Microsoft Excel, there is a very easy way to convert strings to numbers:
https://support.microsoft.com/en-us/kb/291047

Please add a similar "Convert to Number" menu item to LibreOffice.

Thanks!

Comment 1 Cor Nouws 2015-05-19 22:12:20 UTC

Hi S,

Thanks for sending the idea. Known as 33962 already.

*** This bug has been marked as a duplicate of bug 33962 ***