Results 1 to 3 of 3

Thread: Decimal signs "," & "." - causing issues
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Decimal signs "," & "." - causing issues

    Hi,

    I have a template that calculates costs for services per month based on input from managers. I have set dot/"." as default decimal sign whilst everyone else have comma/"," (applies to all excel files you open). Due to this, they can not see the calculated costs for rows that contain cells using comma as decimal sign. Formula then returns "add data". If they change to "." in their settings, all numbers appear since all "," turns to ".". The problem is, they are all used to "," and do not want to work with ".".

    Please see picture: https://imgur.com/a/jiEweZA

    Any suggestions on how I can make the numbers appear regardless of decimal sign settings?

  2. #2
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Decimal signs "," & "." - causing issues

    Bumping this thread, are there no solutions to this issue?

  3. #3
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Decimal signs "," & "." - causing issues

    No one?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •