That's not a bug. Applying a cell format never changes the cell content. The ' apostrophe in the input line is prepended so that when editing the content it stays text. Removing the ' will accept the input as number then. You can bulk change multiple cells by selecting them, apply a number format and then invoke Find&Replace Search: ^. Replace: $0 and in options check regular expression and selection only. Or use the Convert-Text-To-Number extension from http://extensions.libreoffice.org /extension-center/ct2n-convert-text-to-number-and-dates
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1305877 Title: [Upstream] ' prepended when applying Number Category to Text Category cell with a number in it To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1305877/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs