Forum Discussion

eric_alain's avatar
eric_alain
Copper Contributor
Aug 09, 2022

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

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 E...
Excel on mobile
dscheikey's avatar
dscheikey
Bronze Contributor
Aug 11, 2022

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.

  • eric_alain's avatar
    eric_alain
    Copper Contributor
    Aug 20, 2022

    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

Resources