Windows 10: Not able to change from scientific formatting to number

Discus and support Not able to change from scientific formatting to number in Microsoft Windows 10 Store to solve the problem; Whenever I am starting a new spreadsheet, existing spreadsheet or a new file and writing number, it automatically shifting to scientific format. And... Discussion in 'Microsoft Windows 10 Store' started by MadhavKhandelwal, May 29, 2020.

  1. Not able to change from scientific formatting to number


    Whenever I am starting a new spreadsheet, existing spreadsheet or a new file and writing number, it automatically shifting to scientific format. And when try to remove decimals it is changing to 0.

    This problem raised today itself and is there in every cell.

    Can anybody please help?

    :)
     
    MadhavKhandelwal, May 29, 2020
    #1
  2. John Sarc Win User

    Changing Time Format

    Hi Mary,

    There's a possibility that the set up time format in your computer Basic Input/Output System (BIOS) is military time. To have this checked, you can try to reset the time of your computer through Control Panel. See the steps below on how to do
    so:

    • Open Control Panel > Clock, Language, and Region >
      Change date, time, or number formats. This would open the
      Region
      window.
    • From there, click on Additional settings at the bottom part. It will open the Customize Format.
    • Click Reset; then, OK.

    The steps should work; however, if not, we suggest that you contact manufacturer and have the BIOS time checked.

    Let us know what happens after doing the suggestions .
     
    John Sarc, May 29, 2020
    #2
  3. Fernandz Win User
    How To Format A Write Protected Flash Memory ?

    ¿You already tried this one?...

    Run CMD


    1. diskpart
    2. list disk

    Then in the 3º step, put the correct number of disk in the list for the usb flash (if it's listed in disk 3, then you'll have to write select disk 3).

    2. select disk #
    3. clean
    4. create partition primary
    5. select partition 1
    6. active
    7. format fs=fat32
    8. assign
    9. exit

    with that commands you will format the flash drive in fat32, if you have a large drive you can select also "format fs=ntfs" in step 7.

    good luck!
     
    Fernandz, May 29, 2020
    #3
  4. Not able to change from scientific formatting to number

    WHY IS PEOPLE APP MOBILE DETAILS IN SCIENTIFIC NUMBERING

    people app on both pc and phone shows some mobile numbers in an undecipherable scientific format...

    has ms been migrating my database and converted some to this useless format???

    can I get them to fix this please...

    eg its like 4.4696E+11

    george
     
    georgeszubinskime, May 29, 2020
    #4
Thema:

Not able to change from scientific formatting to number

Loading...
  1. Not able to change from scientific formatting to number - Similar Threads - able change scientific

  2. enter phone number format

    in Windows 10 Customization
    enter phone number format: format to enter phone number https://answers.microsoft.com/en-us/windows/forum/all/enter-phone-number-format/73c14c01-12ac-4ab9-9ec1-a2a3479df8b9
  3. Number format

    in Windows 10 Customization
    Number format: When needs to change number format to context in windows 10 , it doesn't appear in control panel > region > format > additional setting ? where can I fined it ? do I have a problem with windows installation or set up?...
  4. How to change number format in Windows 10 negative numbers in parentheses

    in Windows 10 Customization
    How to change number format in Windows 10 negative numbers in parentheses: Hello. I would like to change the number format in Windows 10. I read the following pages below from answers to other posts but they are not helpful. The number format setting is not with Time & Date anymore. I cannot use the normal 'currency' or 'accounting' format in excel...
  5. Formatting hard disks with numbers?

    in Windows 10 Drivers and Hardware
    Formatting hard disks with numbers?: Hi I have a server and I'm running out of letters to add hard drives I know that with raid or pools you can combine multiple drives but I would like to use numbers instead of letters that are not recognized in windows is there a possibility zb in windows server 2019...
  6. INCORRECT FORMAT NUMBER

    in Windows 10 Software and Apps
    INCORRECT FORMAT NUMBER: I tried to enter my p**** n*****, and it says, 'Incorrectly formatted phone number'. What to do now? *personal information DO NOT ENTER https://answers.microsoft.com/en-us/windows/forum/all/incorrect-format-number/af36edd4-b1df-406d-ac71-f1bac4b13083
  7. Is there any way to change the numbers script format into the western arabic numbers ?

    in Windows 10 Ask Insider
    Is there any way to change the numbers script format into the western arabic numbers ?: [ATTACH] submitted by /u/bottomtextboy [link] [comments] https://www.reddit.com/r/Windows10/comments/i9nztp/is_there_any_way_to_change_the_numbers_script/
  8. How do I enter numbers in scientific notation in the calculator?

    in Windows 10 Software and Apps
    How do I enter numbers in scientific notation in the calculator?: I want to calculate the pH of a solution knowing its [H+} using the formula pH = -log({H+], where [H+] is 6.5x10^-5. is there a simple way to enter 6.5e-5, and the rest of this calculation?...
  9. How to change number on windows startup news feed from Native (Thai number format) to...

    in Windows 10 Customization
    How to change number on windows startup news feed from Native (Thai number format) to...: How to change number on windows startup news feed from Native (Thai number format) to Arabic number format (Ex. 12345) [ATTACH] https://answers.microsoft.com/en-us/windows/forum/all/how-to-change-number-on-windows-startup-news-feed/703e80e4-28f6-456e-8dc0-a02468a3447f
  10. Scientific Atlanta DPW939 driver

    in Windows 10 Drivers and Hardware
    Scientific Atlanta DPW939 driver: Had this device working on windows 7 fine, cannot find any drivers for it now. Not for any windows versions. Any Help? 80645