Windows 10: EXCEL uses (any version) change format from dec comma to dec point

  1.    27 Jan 2018 #1

    EXCEL uses (any version) change format from dec comma to dec point


    Hi there

    I've got a simple question used to do it in my head - but forgotten.

    A piece of software is blowing up because when reading an uploaded excel file it's not interpreting my numbers correctly -- I've got say 424,94 USD which in the UK should be written as 424.94 and for bigger amounts for example 190.293,51 should be 190,293.51 The application is terminating with Number convert !!.

    The application software is reading file as a CSV file -- that's not a problem - it's the number format of the decimal fields.

    I don't want to edit the whole thing line by line -- is there a quick way of editing this -- also I don't want to change EXCEL so it always uses UK/US data format -- just want to change the 2 columns in the spreadsheet.

    Click image for larger version. 

Name:	excel.png 
Views:	3 
Size:	93.8 KB 
ID:	174383

    Thanks


    Cheers
    jim
      My ComputerSystem Spec

  2.    27 Jan 2018 #2

    Click column header and do find and replace operating on all cells in that column?

    Indeed if I click one column header, and CTRL click the other, I have 2 columns selected - as you have- and can do just one replace operation. (Hint- I use WPS office not EXCEL)
      My ComputerSystem Spec

  3.    27 Jan 2018 #3

    Yup.. can do w/o formatting...

    Click image for larger version. 

Name:	Capture4.PNG 
Views:	19 
Size:	11.6 KB 
ID:	174390
      My ComputerSystem Spec

  4.    27 Jan 2018 #4

    Have you changed your LOCALE setting?
      My ComputerSystem Spec

  5.    27 Jan 2018 #5

    margrave55 said: View Post
    Have you changed your LOCALE setting?
    Hi there

    this is a one off so I don't want to do that
    @Superfly --that's the solution

    Changed to TEXT, did the edit in a few steps -- changed the '.' to something like '@', changed the ',' to '.', removed the '@' to nothing' (not space but null) and then all fine as then I rest thing to NUM and software loaded into target file on the work application server.

    Thanks

    Cheers
    jimbo
      My ComputerSystem Spec


 

Related Threads
I upgraded my Windows 10 on 23-9-16. now when I open Excel 2010 the default display is changed. When Excel was opened previously the 'Home' tab was expanded and the various groups are visible. Similarly when any other tab is clicked the groups are...
Excel 2010 I have a column of 22,000 phone numbers (and an additional column of fax numbers). I'm trying to convert the numbers from nine digits to nine digits with hyphens. I copied and renamed the original document. There are no...
I have both Excel 2000 and Excel 2013 on my Windows 10 machine for reasons that don't need enumeration here. I am working with a program now that will export/import to Excel, but it looks like it might work only with Excel 2013. However, when I do...
Win+Space used to activate Aero Peak, but now it's Win+Comma. Is there any way to change this behavior?
In Excel 2010 the default comment font has been bold for me for as long as I can remember (even in a fresh install in Win 10). In this post Title Bar Text Size - Change in Windows 10 - Windows 10 Forums The common fix of changing the tooltip font...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 11:56.
Find Us