In Excel Android, how can I change the dot to a comma (keyboard) key?

New Contributor

Hello

 

I work with an excel spreadsheet but it is impossible to sum any figures as it is a dot key.

With the french Excel version, only the comma key runs.

 

I know how to fix it with Windows Excel but with Excel Android I do not know where is the solution?

 

Thanks for your help,

 

Best regards,

 

Eric

 

ps: Excel is installed on a Samsung Tab Galaxy S8 Ultra 14.6"

 

 

 

Bonjour,

 

J'ai installé Excel (premium) sur une tablette Samsung (android) S8 Ultra.

Mais pour saisir les décimales, c'est un point qui s'affiche au lieu de la virgule.

Comment changer le point (de la touche du clavier numérique) en virgule avec Excel pour Android?

 

Merci

 

Cordialement,

 

Eric

2 Replies

Hi @eric_alain

with the NUMBERVALUE() function you can sum the values.

You can specify the decimal separator and the 1000 separator yourself. This makes you independent of the locale.

For example, if your data is in cells A1 - A20:

 

=SUM(NUMBERVALUE(A1:A20,"."))

 

This also works in Excel for Android.

 

To replace all dots with commas, there is also a search and replace function in Excel for Android. It can be found under Search and then under Settings.

Hello @dscheikey

Thanks for your message.

By the way, I only used the search and replace function to do the job.
But as I currently only use Microsoft Excel for ANDROID, it should be nice the comma key would be set up originally (as it is possible to be like that using Excel for Windows).

I guess that Excel for Android is not completely functionnal as it is the case for Windows. 

 

In another way, Excel for Windows is really more powerful comparing Excel for Android.

 

Finally, working with Excel spreadsheets using Android devices like a Samsun Tab, it just like Icould say, if it's correct, "on an ad hoc tool".

Best regards,

Eric