answersLogoWhite

0

Go to the Edit menu and pick Replace. In the "Find what" box enter the comma and in the "Replace with" box enter the full stop. Then you can replace them. If you are certain you want to do it for all full stops you can click Replace All. It will only change them where you have literally type them in. Decimal points that are in calculations as a result of formulas will not be replaced.

The above is a quick fix but the data entry isn't correct.

To change from the "," appearing when entering a "." as a decimal point you need to change the regional and language settings in Windows.

Go to your 'Control Panel' and open 'Regional and Language Options'. You can leave the language as is, click on the 'Customize this format...' button.

Now change the "Decimal symbol" to a "." and the "digit grouping symbol" to a ","

Problem solved.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

What is full color in Microsoft Excel?

blue


What other program is similar to Excel in Open Office?

Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.


How can one user get full Microsoft Excel help?

Microsoft Excel has a help function built into it that will search through a pre-installed FAQ to help find an answer. If you cannot find an answer there Microsoft support can answer any question you have.


What type of a database is Microsoft Excel?

Microsoft Office Access uses a database type known as the Microsoft Jet Database Engine. You can learn more about Microsoft Access online from the Wikipedia.


How do you get Excel and Word?

You can download trial versions from the Microsoft website, but to get full versions you would have to buy them, by getting a version of Microsoft Office.


Why use Ms access to create databases and why not use Microsoft Excel?

Access is a database. Excel is a spreadsheet. Both are useful to displaying data systematically, but a database is enormously more flexible. Access is a relational database, which is even more flexible than an ordinary database and permits the data to be manipulated in many ways. +++ It's not "instead of" but "both" - using whichever is the better for the given work. ' It does depend on your purposes. Excel is by far the better if you need only a single table, or if you need to embed a lot of mathematical formulae in the spread-sheet - though MS has ruined what had been its nearly-good graph routines. A database table looks like a spread-sheet page, but it lacks the rapid copying functions that are valuable features in Excel.


What does the microsoft exchange entail?

According to the Microsoft website you are able to exchange and refund their products within a certain length of time. Please visit http://www.microsoft.com/mscorp/productrefund/refund.mspx for their full policy on exchanges and refunds.


What are the benefits of buying Microsoft Office 2007?

There are a number of benefits to buying Microsoft Office 2007. The Microsoft Office suite of products offer a full word processing program, as well as accounting and spreadsheet software like Excel.


Are there any programs online that offer training for software program such as Microsoft Excel?

Youtube has free informative videos of excel tutorials. In addition to videos there are paid seminars and programs you can buy that will give you the knowledge you need to full learn how to use excel.


What are the 7 horizontal cell alignments in Microsoft Excel?

There are seven cell alignments in Excel, but not all are horizontal. 4 x HORIZONTAL: left, center, right, full 3 x VERTICAL: top, center, bottom


Is Microsoft Access better than Microsoft Excel?

Both Excel and Access are capable of doing a lot of things that the other can do. Excel is a spreadsheet application and Access is a database application, so they are used for different things. They are different kinds of applications so they cannot be compared in full, only on certain things. If you want to do a lot of databasing things, while you can do them in Excel, Access is better for it. If you are doing a lot of calculations, then Excel is better although Access can do calculations too. So it depends on what you want to do.


How do you get excel spreadsheet for free?

You can download a 90-day trial from Microsoft. However, if you get a full version without paying for it, you most likely would be a software pirate.