+6
Hallo,
I’ve noticed that there’s a strange behaviour of a saved numeric values written in Excel shhet using Excel Basic package, causing the written cells marked with “Numeric value stored as an text” error.
There’s a possibility to turn of the notification’s, buth the values are still left alignment, and there;s no aggregation of values, Only if you click twice on a specific cell it becomes proper numeric vale like below:
How to deal with that kind of behaviour?
greeting, Michal
+13
Hi
If you are testing this on a single machine, please follow the below steps.
On the Excel menu, click Preferences.
Under Formulas and Lists, click Error Checking and uncheck the Enable/Disable background error checking check box.
+6
Hi
If you are testing this on a single machine, please follow the below steps.
On the Excel menu, click Preferences.
Under Formulas and Lists, click Error Checking and uncheck the Enable/Disable background error checking check box.
-----------------
Hallo
the procedure You’ve mentioned turns off the notifications, but the values are still bot recongnized as numeric, only double clicking sets them as proper numeric value,
what i noticed, that this issue doesn’t occur when using Excel Advantage Package,
+13
Hi
If you are testing this on a single machine, please follow the below steps.
On the Excel menu, click Preferences.
Under Formulas and Lists, click Error Checking and uncheck the Enable/Disable background error checking check box.
-----------------
Hallo
the procedure You’ve mentioned turns off the notifications, but the values are still bot recongnized as numeric, only double clicking sets them as proper numeric value,
what i noticed, that this issue doesn’t occur when using Excel Advantage Package,
Have you tried with changing the Package version?
+6
Hi
If you are testing this on a single machine, please follow the below steps.
On the Excel menu, click Preferences.
Under Formulas and Lists, click Error Checking and uncheck the Enable/Disable background error checking check box.
-----------------
Hallo
the procedure You’ve mentioned turns off the notifications, but the values are still bot recongnized as numeric, only double clicking sets them as proper numeric value,
what i noticed, that this issue doesn’t occur when using Excel Advantage Package,
Have tried with changing Package version?
I’ll try with lower package versions then
greetings
+6
Hi
If you are testing this on a single machine, please follow the below steps.
On the Excel menu, click Preferences.
Under Formulas and Lists, click Error Checking and uncheck the Enable/Disable background error checking check box.
-----------------
Hallo
the procedure You’ve mentioned turns off the notifications, but the values are still bot recongnized as numeric, only double clicking sets them as proper numeric value,
what i noticed, that this issue doesn’t occur when using Excel Advantage Package,
Have tried with changing Package version?
I’ll try with lower package versions then
greetings
Dear
where to look for next?
+13
Hi
If you are testing this on a single machine, please follow the below steps.
On the Excel menu, click Preferences.
Under Formulas and Lists, click Error Checking and uncheck the Enable/Disable background error checking check box.
-----------------
Hallo
the procedure You’ve mentioned turns off the notifications, but the values are still bot recongnized as numeric, only double clicking sets them as proper numeric value,
what i noticed, that this issue doesn’t occur when using Excel Advantage Package,
Have tried with changing Package version?
I’ll try with lower package versions then
greetings
Dear
where to look for next?
You may try raising a support ticket here for this for better assistance.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.