Ask Your Question

Convert to Number [closed]

asked 2013-10-22 13:26:26 +0200

smbhatt gravatar image

no option of Convert to No. From ' in cell (character field).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-12 06:28:58.886058

2 Answers

Sort by » oldest newest most voted

answered 2013-10-23 03:08:15 +0200

horst gravatar image

In Calc there are two functions VALUE(text) and NUMBERVALUE that convert text as numbers to real numbers.

edit flag offensive delete link more

answered 2013-10-22 15:43:23 +0200

m.a.riosv gravatar image
edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-10-22 13:26:26 +0200

Seen: 767 times

Last updated: Oct 23 '13