Forum Discussion

Ann_Woo's avatar
Ann_Woo
Copper Contributor
Jun 30, 2021
Solved

Excel treats numbers as text

Hello Community,   I have downloaded an excel file from Visma (accounting software) in csv format. Excel does not recognize the numbers as such and does not even show any error warning (normally y...
excel
Formulas and Functions
  • Ann_Woo's avatar
    Ann_Woo
    Jun 30, 2021

    Ann_Woo 

     

    I found the solution with a colleague: I need to replace points and comma for decimals and thousands. We work with the American decimal system not with the European system 😄 

Ann_Woo's avatar
Ann_Woo
Copper Contributor
Jun 30, 2021

Ann_Woo 

 

I found the solution with a colleague: I need to replace points and comma for decimals and thousands. We work with the American decimal system not with the European system 😄 

Resources