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

Discus and support EXCEL uses (any version) change format from dec comma to dec point in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by jimbo45, Jan 26, 2018.

  1. jimbo45 Win User

    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.


    EXCEL uses (any version) change format from dec comma to dec point [​IMG]


    Thanks


    Cheers
    jim

    :)
     
    jimbo45, Jan 26, 2018
    #1

  2. Does the N95 come with an Excel viewer?

    Yes you can view basic excel files using the built in quick office software.

    It only displays basic features and does not show any advanced formatting.

    .
    Message Edited by psychomania on 06-Dec-200701:54 PM
     
    psychomania---01, Jan 26, 2018
    #2
  3. Wrong characters in sms export

    I try to explain better with an example.

    I write a message containing the latin small letter a with grave (dec 224 in extended ascii). I see this character correctly both on the phone and in the Nokia Communication Centre.

    Now I select the message in Communication Centre and I export it in .csv format.

    If I open the file using UltraEdit, Notepad or MS Excel I always see the latin capital letter A with tilde (dec 195 in extended ascii).

    With some letters, the original character is trasformed in a couple of characters.
     
    blongo---01, Jan 26, 2018
    #3
  4. dalchina New Member

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

    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)
     
    dalchina, Jan 26, 2018
    #4
  5. Superfly Win User
    Yup.. can do w/o formatting...


    EXCEL uses (any version) change format from dec comma to dec point [​IMG]
     
    Superfly, Jan 26, 2018
    #5
  6. Have you changed your LOCALE setting?
     
    margrave55, Jan 26, 2018
    #6
  7. jimbo45 Win User
    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
     
    jimbo45, Apr 5, 2018
    #7
Thema:

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

Loading...
  1. EXCEL uses (any version) change format from dec comma to dec point - Similar Threads - EXCEL uses version

  2. missing past updates dec 12 and beond have the latest one dec 19 history of past missing...

    in Windows 10 Installation and Upgrade
    missing past updates dec 12 and beond have the latest one dec 19 history of past missing...: missing past updates dec 12 and beond have the latest one dec 19 history of past up dates missing how can i get them??? https://answers.microsoft.com/en-us/windows/forum/all/missing-past-updates-dec-12-and-beond-have-the/2fb4770d-2ce0-4fdd-8d83-78c90d9da124
  3. Windows update 15th Dec 2018

    in Windows 10 Installation and Upgrade
    Windows update 15th Dec 2018: You did an update yesterday, the first I knew was a message stating you would be restarting.... now Today, I cannot find files (yet again what is it with your updates and deleting files). Where are they. One especially is pinned on Excel and now doesn't exist. It has a...
  4. 11 Dec 2018 Windows 10 Updates

    in Windows 10 Installation and Upgrade
    11 Dec 2018 Windows 10 Updates: Hi: I found a bunch of updates ready to install on my Win 10 Pro Desktop Machine, so I went ahead and did the updates, and then the machine started to go thru the reboot process and that is where things went bad. I no longer have a desktop available and if I try to Shift,...
  5. New Your Phone Companion app 3.3.5_54212 version for Android - Dec. 12

    in Windows 10 News
    New Your Phone Companion app 3.3.5_54212 version for Android - Dec. 12: Keep your devices in sync – instant access to your phone’s texts, photos, docs, and more on your PC. You love your phone. So does your PC. With Your Phone Companion app, easily sync your Android to your Windows 10 PC for instant access to your phone's photos, texts, docs,...
  6. excel conditional formating

    in Microsoft Office and 365
    excel conditional formating: Hi to all,,, I am using excel 2016 and I have a 2 rows of data of which the top row consists of W or L and the row underneath consists of numbers that can be a number from 1 to 8. If the top cell is an L and the cell below is >6 I want the selected cell to be formatted with a...
  7. VMWARE version 11 to appear in Dec

    in Windows 10 Virtualization
    VMWARE version 11 to appear in Dec: Hi there VMWARE users - a new release is appearing in Dec - version 11 - hopefully they will have done SOME testing with W10 VM's. Currently I'm playing around with HYPER-V and apart from some networking issues I quite like it - however I might try the 30 day free trial...
  8. Dec 2 update broke sleep

    in Windows 10 Updates and Activation
    Dec 2 update broke sleep: lost ability for computer to sleep after Dec. 2 update. Had this stopping it: [DRIVER] \FileSystem\srvnet An active remote client has recently sent requests to this machine. Eventually found this worked: Why Wons Tech Talk I then followed this sites...
  9. Upgrade from Windows 8.1 After Dec. 31

    in Windows 10 Installation and Upgrade
    Upgrade from Windows 8.1 After Dec. 31: I think I was told that it's possible to do a Clean Install with Windows 10 from windows 8 without the need to Upgrade through Assistive Technologies First, is this true? I'm also wondering, can this be done after the deadline of Dec, 31 as I understand it? I assume it...
  10. Watch the Game Awards 2017 Live Dec. 7th

    in Windows 10 News
    Watch the Game Awards 2017 Live Dec. 7th: The Game Awards 2017 live show will air from Microsoft Theater in Los Angeles on Thursday December 7th, 2017- 9PM ET/ 6PM PT. Celebrate the best games and gamers of 2017 and get a preview of the most anticipated games of the future. The Game Awards will be streamed on a...