Translations:Faq/Calc/How to convert number text to numeric data/6/en

From The Document Foundation Wiki
Jump to navigation Jump to search
  • mark the cell range containing the data to convert
  • press Ctrl+M or right click on the marked range to get the context menu and select Clear Direct Formatting
  • press Ctrl+H or choose Edit -> Find & Replace from the menu
    • enter Find: .
    • enter Replace: ,
    • under Other options
      • activate Current selection only
      • deactivate Regular expressions
    • hit Replace All