Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Currency number to general number  (Read 4468 times)

0 Members and 1 Guest are viewing this topic.

SuperDave

    Topic Starter
  • Malware Removal Specialist


  • Genius
  • Thanked: 1020
  • Certifications: List
  • Experience: Expert
  • OS: Windows 10
Currency number to general number
« on: October 18, 2020, 07:26:07 PM »
I hope someone can help me with this. I keep two Xcel files; one for electric consumption and the other for my bank account. Everytime I entered for example $330.00 in my bank account it would only enter $330. I had to manually enter the two zeros.  I did something in formatting the cells to add the two zeros and now when I try to enter my elective consumption it goes into each cell as a currency number with a decimal and two digits. I tried to right-click the cell and select General but no luck. Does anyone have any suggestions how to fix this?
Windows 8 and Windows 10 dual boot with two SSD's

strollin



    Adviser
  • Thanked: 84
    • Yes
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Re: Currency number to general number
« Reply #1 on: October 19, 2020, 05:18:44 AM »
Instead of selecting General, select Number.  It will then allow you to decide how many decimal places to use.  If you only want the number and no decimal places, set the number of decimal places to 0.  Additionally, you could select custom and then use 0 as the pattern which means no decimal places.

SuperDave

    Topic Starter
  • Malware Removal Specialist


  • Genius
  • Thanked: 1020
  • Certifications: List
  • Experience: Expert
  • OS: Windows 10
Re: Currency number to general number
« Reply #2 on: October 19, 2020, 03:52:09 PM »
Instead of selecting General, select Number.  It will then allow you to decide how many decimal places to use.  If you only want the number and no decimal places, set the number of decimal places to 0.  Additionally, you could select custom and then use 0 as the pattern which means no decimal places.
I tried that with no success. The only thing that works is if I select the cell with a number in it and select "Replace" and enter the same number with no decimal point. It's also strange why changing one method in a worksheet will change the method in another worksheet.
Windows 8 and Windows 10 dual boot with two SSD's

Term_ite



    Beginner
  • Thanked: 9
    • Computer: Specs
    • Experience: Familiar
    • OS: Windows 10
    Re: Currency number to general number
    « Reply #3 on: October 20, 2020, 08:04:09 AM »
    Hi Dave
    On any of your worksheets click on the file tab. On the left click the options. (These are universal options affecting ALL worksheets) Select Advanced. In the editing options make sure “Automatically Insert Decimal Point" is Unchecked. This may solve your problem.
    « Last Edit: October 20, 2020, 08:20:46 AM by Term_ite »

    SuperDave

      Topic Starter
    • Malware Removal Specialist


    • Genius
    • Thanked: 1020
    • Certifications: List
    • Experience: Expert
    • OS: Windows 10
    Re: Currency number to general number
    « Reply #4 on: October 20, 2020, 03:58:47 PM »
    Thanks for the advice. Unfortunately, my 2002 version of Xcel does not have that option.
    Windows 8 and Windows 10 dual boot with two SSD's

    Term_ite



      Beginner
    • Thanked: 9
      • Computer: Specs
      • Experience: Familiar
      • OS: Windows 10
      Re: Currency number to general number
      « Reply #5 on: October 21, 2020, 08:36:31 AM »
       Hi Dave
      Check this URL out.

      https://excel.tips.net/T002755_Fixing_the_Decimal_Point.html

      I think this could be what you are looking for.

      SuperDave

        Topic Starter
      • Malware Removal Specialist


      • Genius
      • Thanked: 1020
      • Certifications: List
      • Experience: Expert
      • OS: Windows 10
      Re: Currency number to general number
      « Reply #6 on: October 21, 2020, 03:36:43 PM »
      Thanks Term_ite. I just had to reverse engineer the sheet and it worked well.
      Windows 8 and Windows 10 dual boot with two SSD's