Numbers format on Excel

Question

I've got a job which I am not allowed to use SQL/BigQuery to analyze data, because of the compliance/data security, so I must download data from a dashboard.

In the dashboard I just can download in a TSV file. When I open it in an Excel spreadsheet, all numbers are in a strange format.

For example, for Y/Y15 in below image, the Y/Y15 is a 217% percentage number, but how can I convert it to percentage format or even to a number format?

I've tried the formula:

=VALUE(SUBSTITUTE(tbl[@[Y/Y5]];".";","))/100000000000000000

This can solve just for extensive numbers. The problem is sometimes this number will be like W/W14, which means the percentage will be smaller and the division /1000... will not work, because I am trying to automate these steps into Excel, once I am not allowed to use BigQuery.

Also I've tried to save the file as xls and reopen it, but with no changes in format numbers. And also I've tried to find something in other sources, but with no success.

You need to show us a small sample of the TSV file and any relevant nationality settings. What you describe looks like some local convention of . vs , in larger numbers. You wouldn't believe how many silly ways of writing out big numbers there are globally. You can probably tell the data source not to insert such distracting fluff. — Martin Brown
– Martin Brown, Commented Jun 30 at 19:07

rotabor · Accepted Answer · 2025-06-30 20:09:16Z

0

You need to import data rather than open the file:

Then transform data changing the locale:

answered Jun 30 at 20:09

rotabor

5,6072 gold badges5 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Numbers format on Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related