https://issues.apache.org/ooo/show_bug.cgi?id=124812

--- Comment #4 from mroe <[email protected]> ---
(In reply to SPACESH1P from comment #3)
> Ok, thanks for your help. I still dont understand, why - when i select the
> column and choose the format number - some of the cells remain in the format
> text.

There is a difference between a digit of a number and the character for this
digit. You can't convert a character to a digit by changing the format.

1. Change the format of the cells explicitly to a number format.
2. Select the cell range.
3. Edit → Find & Replace:
... Search for: .*
... Replace with: &
... [More Options]:
.... [x]Current selection only
.... [x]Regular Expressions
4. [Replace ALL]

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

Reply via email to