• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

can not calculate

P

Pofski

Member
Hi,

this will prolly be something stupid, but here goes.

I have a sheet where i have to put some calculations,
but for some reason, when i have a number with a "," it doesn't want to be recognized as a number.

I tried different things already (putting it as =text(a1,"@"), or using the format cell to put it as number, or taking the cell and doing +0, but i can't get it to work.
Could somebody help me out here? I don't see it.

Attached you will find an example.

Thank you for your help
 

Attachments

  • numbers.xlsx
    9.4 KB · Views: 5
Hi Pofski,

That "," is converting it to string. If your Intention is to put a decimal over there, try below below formula.

=--SUBSTITUTE(A1,",",".")

Regards,
 
Hi Pofski ,

In your system , what character is used for the following ?

1. The character which separates the integer portion from the decimal portion in a decimal number

In my system , this is the period "." e.g. 31.283 , where 31 is the integer portion , and 0.283 is the decimal portion.

2. The character which acts as a thousands separator

In my system , this is the comma "," e.g. 5,000 and 5,000,000

In this case , Excel will recognize the comma only in specific positions e.g. 5,000 and 50,000 will be correctly recognized , but 5,00 will not.

Narayan
 
....

Like i said, i feel stupid now :)

Thanks Narayan, will use a substitute to transform all the "," to ".".

Sincerely
 
You must log in or register to reply here.
Back
Top