SOLVED

Excel treats numbers as text

%3CLINGO-SUB%20id%3D%22lingo-sub-2500500%22%20slang%3D%22en-US%22%3EExcel%20treats%20numbers%20as%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2500500%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20downloaded%20an%20excel%20file%20from%20Visma%20(accounting%20software)%20in%20csv%20format.%3C%2FP%3E%3CP%3EExcel%20does%20not%20recognize%20the%20numbers%20as%20such%20and%20does%20not%20even%20show%20any%20error%20warning%20(normally%20you%20get%20the%20small%20green%20rectangle%20in%20the%20upper%20left%20corner%20of%20the%20cell).%3C%2FP%3E%3CP%3EThe%20following%20trials%20all%20failed%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20use%20%22paste%20special%22%20with%20add%20or%20multiply%3C%2FP%3E%3CP%3E-%20use%20%3Dvalue%20formula%26nbsp%3B%3C%2FP%3E%3CP%3E-%20use%20%22Data%22%20-%20%22Text%20to%20Columns%22%20%22Fixed%20with%22%20%22Finish%22%3C%2FP%3E%3CP%3E-%20change%20the%20format%20from%20%22general%22%20to%20number%3C%2FP%3E%3CP%3E-%20converted%20csv%20to%20xlsx%20via%20an%20online%20converter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20attached%20the%20file.%20Is%20there%20anybody%20who%20knows%20the%20redeeming%20solution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EAnn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2500500%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2500517%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20treats%20numbers%20as%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2500517%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1001160%22%20target%3D%22_blank%22%3E%40Ann_Woo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20the%20solution%20with%20a%20colleague%3A%26nbsp%3BI%20need%20to%20replace%20points%20and%20comma%20for%20decimals%20and%20thousands.%20We%20work%20with%20the%20American%20decimal%20system%20not%20with%20the%20European%20system%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 you get the small green rectangle in the upper left corner of the cell).

The following trials all failed:

 

- use "paste special" with add or multiply

- use =value formula 

- use "Data" - "Text to Columns" "Fixed with" "Finish"

- change the format from "general" to number

- converted csv to xlsx via an online converter

 

Please find attached the file. Is there anybody who knows the redeeming solution?

 

Kind regards,

Ann

1 Reply
best response confirmed by Ann_Woo (New Contributor)
Solution

@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