H
H
hakerhamann2022-01-18 19:24:55
Google Sheets
hakerhamann, 2022-01-18 19:24:55

What cell format to use in google spreadsheet for phone number?

Condition: a phone number in the form of +7 123 456 7899 or in the form of +7123456789 arrives in the table cell from the telegrams of the bot. The cell returns an error.
Question: what formatting to create for this cell so that the numbers are normally displayed in it?
It is not possible to send a number with a space or an apostrophe before the plus sign.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2022-01-18
@ForestAndGarden

The cell must initially be in the "Text" format.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question