Re: Covert strings to numbers
- From: John Denker <jsd av8n com>
- To: gnumeric-list gnome org
- Subject: Re: Covert strings to numbers
- Date: Sun, 18 Aug 2013 04:51:32 -0700
On 08/17/2013 10:13 PM, Lumaja wrote:
I get this figures in different cells as strings they can be converted to
numbers without the spaces.
786 879
3 825 647
4 612 526
How to convert them
This should do it:
=value(substitute(A1," ",""))
If not, please clarify the question.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]