NUMBERS, Convert Text into Number

Question

claudiawats Author

Level 1

11 points

NUMBERS, Convert Text into Number

Hi,

I have a list of data imported from excel to Numbers.

Now the numbers are still in TEXT and I need to convert into Number.

Ex: 1.150,00 --> 1150.00

Please help

MacBook Pro 13", macOS 10.15

Posted on Apr 24, 2020 11:00 PM

Reply

Answer 1

Top-ranking reply

Yellowbox

Level 7

21,915 points

Apr 25, 2020 9:19 AM in response to claudiawats

Hi Claudia,

Fill these formulas down.

Remove the dots.

Formula in C2 =SUBSTITUTE(B2,".","")

Substitute the comma with a dot.

Formula in D2 =SUBSTITUTE(C2,",",".")

Force to a number value by multiplying by 1.

Formula in E2 =D2*1

Thanks, medwds! I had forgotten about that discussion from 2015. Good catch!

Regards,

Ian.

Reply

Answer 2

medwds

Level 4

2,188 points

Apr 25, 2020 1:49 AM in response to claudiawats

See these excellent replies by Yellowbox and Barry in another thread.

If you want to keep just the results, you can copy that column and do Edit > Paste Formula Results onto itself, then delete the column that had the text-formatted cells.

Your actual example of 1.150,00 didn't work for me but I'm guessing that depends on regional settings—it works if I use 1,150.00.

Reply

NUMBERS, Convert Text into Number

Similar questions