Reputation: 13886

Google Spreadsheets: number becomes date after SPLIT

I have this text in A1: 18.03 x 13.76 x 1.48 cm

Then I have this formula: =SPLIT(A1;"x")

Problem is that the output is set with a DATE format. I mean that 18.8 becomes 18/03/2021 instead of 18.8.

I need the output to have an number format instead of date.

How can I sort this out?

Upvotes: 1

Answers (3)

Reputation: 10573

You can use the following

=SPLIT(REGEXREPLACE(B1;"\.";",");"x")

Or even

=SPLIT(REGEXREPLACE(B1;"\.";",");" x")

Functions used:

Upvotes: 3

Reputation: 897

Try

=arrayformula(to_text(split(A1;"x")))

Upvotes: 1

Reputation: 1

try:

=INDEX(TEXT(SPLIT(A1; "x"); "@"))

or use internal formatting and set it to Number

Upvotes: 0