How to make data a number?

K

koliaua2021-01-22 19:07:16

Google Sheets

koliaua, 2021-01-22 19:07:16

How to make data in columns numeric? The format of the cells is numeric, in the settings the country is USA. Function =isnumber() say false.
The data is pulled from the table on screenshot 2, pre-cleared from *%*

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2021-01-22
@koliaua

= VALUE ( SUBSTITUTE (AB2;".";","))

Similar questions

M

Mykyta_M2017-10-21 11:08:49

How to update a spreadsheet sheet in google drive using python? 1Reply

X

xaam2017-11-01 16:43:41

How to automatically highlight text in google spreadsheet? 1Reply

V

Vlad Chiehov2017-11-04 16:16:29

How to get the last number from a column/row in Google Docs? 1Reply

Q

Qwixo2017-11-08 13:54:09

For Google Spreadsheets there is a formula with Arrayformula. How does it work? 3Reply

W

WebAnalytics12017-11-08 17:48:04

How to clean up text from everything superfluous in Google Sheets? 1Reply

Didn't find what you were looking for?

Ask your question