Problems formatting with latest update

%3CLINGO-SUB%20id%3D%22lingo-sub-1821746%22%20slang%3D%22en-US%22%3EProblems%20formatting%20with%20latest%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1821746%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone.%20Thanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20having%20a%20number%20formatting%20issue%20since%20the%20last%20Windows%20update.%26nbsp%3B%20Excel%20does%20not%20work%20for%20me%20the%20way%20it%20used%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20specifically%2C%20I%20get%20data%20in%20Danish%20format%20and%20need%20to%20convert%20it%20to%20USA%20format.%26nbsp%3B%20%26nbsp%3BI%20have%20been%20able%20to%20do%20that%20simply%20by%20formatting%20particular%20columns%2C%20or%2C%20with%20a%20few%20columns%20at%20a%20time%2C%20using%20'text%20to%20columns'.%26nbsp%3B%20Now%20when%20I%20do%20these%20things%2C%20it%20does%20not%20correct%20my%20data.%26nbsp%3B%20I%20don't%20know%20what%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20side%20note%2C%20I%20worry%20that%20the%20windows%20update%20changed%20my%20location.%26nbsp%3B%20I%20have%20tried%20fixing%20that%20and%20it%20didn't%20solve%20the%20problem%2C%20however.%26nbsp%3B%20Can%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1821746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822235%22%20slang%3D%22de-DE%22%3ESubject%3A%20Problems%20formatting%20with%20latest%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822235%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F847091%22%20target%3D%22_blank%22%3E%40Debbiequack1966%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EKnowing%20the%20Excel%20version%20and%20the%20operating%20system%20would%20be%20of%20great%20benefit%20...%20for%20everyone%3A).%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EYou%20can%20find%20the%20Excel%20version%20at%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Efile%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eaccount%3C%2FSPAN%3E%3CBR%20%2F%3EProduct%3CSPAN%3Eversion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWindows%20version%20can%3CSPAN%20class%3D%22%22%3Ebe%20found%3A%3C%2FSPAN%3E%3CBR%20%2F%3Ein%20Search%20write%20the%3CSPAN%20class%3D%22%22%3Ecommand%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EWinver%20and%20Enter%3C%2FSPAN%3E%3CBR%20%2F%3Ea%20window%20appears%20with%20the%3CSPAN%20class%3D%22%22%3Ewin.%3C%2FSPAN%3E%20%3CSPAN%3Eversion%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3Eexample%3A%20Windows%2010%20Version%202004%20(Build%2019041.523)%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CBR%20%2F%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone. Thanks in advance for your help.

 

I have been having a number formatting issue since the last Windows update.  Excel does not work for me the way it used to.

 

More specifically, I get data in Danish format and need to convert it to USA format.   I have been able to do that simply by formatting particular columns, or, with a few columns at a time, using 'text to columns'.  Now when I do these things, it does not correct my data.  I don't know what to do.

 

As a side note, I worry that the windows update changed my location.  I have tried fixing that and it didn't solve the problem, however.  Can anyone help?

3 Replies
Highlighted

@Debbiequack1966 

Knowing the Excel version and the operating system would be of great benefit ... for everyone:).

You can find the Excel version at:
file
account
Product version

Windows version can be found:
in Search write the command
Winver and Enter
a window appears with the win. version
example: Windows 10 Version 2004 (Build 19041.523)
 
Thank you for your understanding and patience

Nikolino
I know that I don't know (Socrates)
 
Highlighted

Hi and thanks!  

See below.

 

 

You can find the Excel version at:
file
account
Product version  Microsoft 365?  Is this what you mean?

Windows version can be found:
in Search write the command
Winver and Enter
a window appears with the win. version
example: Windows 10 Version 2004 (Build 19041.523)  Windows 8 version 6.3

@Nikolino 

 

Does that help?  Thanks again!

Highlighted

@Debbiequack1966 

Here is some information about the versions of MS Office or Excel and MS Windows.
 

About Office: What version of Office am I using?

https://support.microsoft.com/en-us/office/about-office-what-version-of-office-am-i-using-932788b8-a...

 

Which version of Windows operating system am I running?

https://support.microsoft.com/en-us/help/13443/windows-which-version-am-i-running

 

Here are a few steps you can do yourself to fix errors.

 

Repair process for an Office Click-to-Run application does not start

https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/click-to-run-app-repair-pro...

 

Updateverlauf für Microsoft 365 Apps (nach Datum aufgelistet)

https://docs.microsoft.com/de-de/officeupdates/update-history-microsoft365-apps-by-date

 

Hope I could help you at least a little.

Thank you for your patience and time.

I would appreciate your feedback.

 

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.