Forum Discussion
Excel Formulas Not Working On Programme
Do you use comma as decimal separator in the desktop version? If so, use semicolon to separate the arguments of a function:
=CONCATENATE(A2; "_"; B2)
HansVogelaar
It does solve the problem, but only for this specific formula. Nearly every second formula that I use on the Excel desktop version ends up with an error message, so I am forced to use the web app version of Excel. Here is the next example:
After using this simple formula, I get a #VALUE! error on the desktop version of Excel, but there is no problem with it on the web app. Is there any option to import/export formula settings from the web app?
Since you use comma as decimal separator, Q2 should be 742,50 instead of 742.50
(You can see that there is a problem: the value in Q2 is left-aligned. By default, 'real' number values are right-aligned)
How text 742.50 appeared, did you copy/paste it from web?
SergeiBaklan HansVogelaar
It's from an exercise worksheet from a course that I'm currently taking. All I had to do was use the =VALUE() formula to fix the problem.
