https://bugs.documentfoundation.org/show_bug.cgi?id=91399
Bug ID: 91399
Summary: Please add a "convert to number" menu option for cells
starting with an apostrophe
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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!
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
