Forum Discussion
Excel Formulas Not Working On Programme
Hi everyone, I'm new to Excel and I'm having difficulty with some of the functions/formulas. For example, I want to join cell A2 with B2 and place an underscore between them. Whenever I try usin...
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)