Mar 23 2021 07:42 AM
Hi, I have the following problem (I tried google and this forum but found nothing):
I have an external software writing text values to my excel column, and it's working fine. I have around 1400 rows filled by it. I have another column to convert each of these values to General (left is text, right is general:
I am using the following formula:
The problem is: in the past, everything was working fine, but suddenly my columns can't be refreshed. So, when those 1400 rows are filled with new text values, converted columns remain the same, as below:
It gets refreshed when I click on that 0.264 value twice and press enter, then the value is good, but in the past it was done automatically and I didn't have to press enter 1400 times.
Any ideas on how to solve that issue? I have automatic calculation turned on and all other things are correct as well.
Thank you,
Mar 23 2021 08:08 AM
Solution: The method used by Excel to calculate formulas depends on the settings you have made under "Tools, Options" on the "Calculation" tab.
If the "Automatic" option is activated there, Excel automatically recalculates all formulas in the entire workbook each time a cell is entered.
Attention: By pressing the F9 key you activate the manual calculation option.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Mar 23 2021 08:10 AM
Mar 23 2021 08:20 AM
@Wojciech_Plonka
It seems as you don't need any formula to convert the Textual Values into Real Values.
SELECT ALL 1,400 cells > in the user interface click DATA > TEXT TO COLUMNS > FINISH.
--------------------------------------------
Michael (Micky) Avidan
“Microsoft®” MVP – Excel (2009-2022)
ISRAEL
Mar 23 2021 08:45 AM
Mar 23 2021 10:30 AM
Mar 23 2021 11:13 AM
Mar 24 2021 02:48 AM
Jul 13 2021 10:28 AM
Dec 08 2021 06:15 AM
Jun 13 2022 01:09 PM
May 10 2023 08:36 PM
Yes, it's working, Thanks for the solution