CODEWITHSUNDEEP
google-apps-scripttext-formatting
Hermandroid
Hermandroid

Reputation: 2200

How can I get rid of the scientific number formatting of Google Sheets via Google Apps Script?

Is there a way to obtain a cell value from Google Sheets which contains a phone number as text in Google Apps Script.

I mean. My sheet contains a list of employees with names and phone numbers like:

Employee  phone          mail
Emp1.     5544477991     [email protected]
Emp1.     1234567988     [email protected]
...       .......        ......

An on the script I wrote:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
R=sheet.getRange("A1:D2").getValues();
for (var f = 0 ; f<3 ; f++) {
    Logger.log(R[0][f])
}

For 5544477991 I get 5.54447799E9.

How can I get rid of the scientific number formatting of Google Sheets via Google Apps Script?

Upvotes: 2

Views: 5741

Answers (2)

user25279213
user25279213

Reputation: 1

This helped me: When pasting car numbers exponential makes no sense nor will number > number it will add a dot every 1000. Highlight column > format > number > automatic

Upvotes: 0

Hermandroid
Hermandroid

Reputation: 2200

Thanks user1989 using toString() works perfectly.

Upvotes: 1

Related Questions