If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change the axis in excel to the american style
I have a laptop computer that was bought in Portugal. However, I want to
change the style of the Axis to the 'American' stytle versus the 'European' style. For example, in America, if you determine the result for the fraction 1/10 you would write 0.10 as the result. However, in Portugal, you would write 0,10. I can't seem to find the option to switch between the two system. Under 'Format Axis' I can't switch between the two and I can't seem to create the American way of showing the axis. Does anyone know how to do this? Thanks in advance. |
#2
|
|||
|
|||
How do I change the axis in excel to the american style
Set this at the OS level. Assuming this is a Windows machine, change the
'Regional and Language Options' from the 'Control Panel'. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a laptop computer that was bought in Portugal. However, I want to change the style of the Axis to the 'American' stytle versus the 'European' style. For example, in America, if you determine the result for the fraction 1/10 you would write 0.10 as the result. However, in Portugal, you would write 0,10. I can't seem to find the option to switch between the two system. Under 'Format Axis' I can't switch between the two and I can't seem to create the American way of showing the axis. Does anyone know how to do this? Thanks in advance. |
#3
|
|||
|
|||
How do I change the axis in excel to the american style
If you want to leave everything else in the European settings, go to Excel's
Tools - Options - International property page, clear the "Use system separators", and change the decimal and thousands separators. If you want all applications to work in US mode, go to Regional and Language settings in the control panel and change your language to English (US) or customize the settings for your chosen language. -- Peter "Hoquista" wrote: I have a laptop computer that was bought in Portugal. However, I want to change the style of the Axis to the 'American' stytle versus the 'European' style. For example, in America, if you determine the result for the fraction 1/10 you would write 0.10 as the result. However, in Portugal, you would write 0,10. I can't seem to find the option to switch between the two system. Under 'Format Axis' I can't switch between the two and I can't seem to create the American way of showing the axis. Does anyone know how to do this? Thanks in advance. |
#5
|
|||
|
|||
How do I change the axis in excel to the american style
I see this is a very old post, but essentially is have the same problem, only
the solution isn't working. I'm having no problems in the main excel window. A dot is the decimal and I can enter numbers bij only using the numpad. However, when trying to edit axis-settings the values can only be entered with a comma as separator, even though I have my system settings on american as wel as specific excel settings stating that the decimal indicator should be a dot. Anyone else encountered this? Any solutions or workarounds out there? By the way, this occurs in excel 2007 "Tushar Mehta" wrote: Thanks for that. Didn't know XL supported a way of not using the system seperators. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... If you want to leave everything else in the European settings, go to Excel's Tools - Options - International property page, clear the "Use system separators", and change the decimal and thousands separators. If you want all applications to work in US mode, go to Regional and Language settings in the control panel and change your language to English (US) or customize the settings for your chosen language. -- Peter "Hoquista" wrote: I have a laptop computer that was bought in Portugal. However, I want to change the style of the Axis to the 'American' stytle versus the 'European' style. For example, in America, if you determine the result for the fraction 1/10 you would write 0.10 as the result. However, in Portugal, you would write 0,10. I can't seem to find the option to switch between the two system. Under 'Format Axis' I can't switch between the two and I can't seem to create the American way of showing the axis. Does anyone know how to do this? Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot change style after copy/paste | Jeff | New Users | 1 | May 17th, 2005 04:56 PM |
How do I change the size of Value Axis Title box for an Excel Cha. | LISSJMC | Charts and Charting | 1 | April 11th, 2005 03:36 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
modify heading 2 style in Word xp | sam | New Users | 6 | June 9th, 2004 12:03 AM |
change icon of excel file | roland | Setting up and Configuration | 0 | November 25th, 2003 04:13 PM |