Bug 91399 - Please add a "convert to number" menu option for cells starting with an apostrophe
Summary: Please add a "convert to number" menu option for cells starting with an apost...
Status: RESOLVED DUPLICATE of bug 33962
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2015-05-19 21:52 UTC by S.
Modified: 2015-05-19 22:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description S. 2015-05-19 21:52:10 UTC

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:

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:

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

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 ***