Problems formatting with latest update

Copper 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

@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)
 

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

@NikolinoDE 

 

Does that help?  Thanks again!

@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.