0

I noticed that is not possible to use a number like "12.6" in a cell of type "number" but is only accepted a number like "12,6". How can I allow the use of the "dot" character?

Thanks, Luca

  • 1
    Have you checked that this is not dependent on the locale setting of the current user? I expect it to work if the locale is set to US – Florian Heer Mar 18 at 12:49
  • 1
    Your user locale will determine the thousands separator and decimal separator. Try using a locale that uses full-stop (.) for the decimal separator. – sfdcfox Mar 18 at 12:53
  • I want to use both "." and "," – Luca Daneluzzo Mar 18 at 13:08
  • Or, if it is possible, when a user type "." I want to dinamically change "." to "," – Luca Daneluzzo Mar 18 at 13:10
  • @LucaDaneluzzo tip: tag the users that commented your post so that they can see your response – J.Dillinger Mar 19 at 15:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.