Post a reply

8 posts • Page **1** of **1**

- MS EXCEL
- WINDOWS SERVER
- c++
- Windows
- MS SQL SERVER
- tcl
- javascript
- robots
- Visual Studio .Net
- Computer architecture

### Jump to:

- 1. Earliest and latest dates that can be correctly represented in Exc

What are the earliest and latest dates that can be correctly represented in Excel? - 2. Co-ordinates

Hi,I have two circles. I have the co-ordinates and radius of the firstcircle and the second circle. The condition that should be checked is,if the co-ordinates of the second circle is in the range of the firstcircles, then it should assign a value (0, 1, or X) based on thecondition.For example, the co-ordinates and radius of the first circle is (x,y,r) = (1.080, 3.520, 0.062) and for the second circle, it is (x,y, r) =(0.922, 3.4411, 0.295). I want to check if the second circle is in therange on the first circle and if it is in the range, the value shouldbe 0. If the second circle is out of range, the value should be 1. Ifthe second circle is blocking the first circle or very closelytouching the first circle, the value should be X. The answer to theproposed problem should be 0 as I have a picture.Are there any co-ordinate functions in excel? I would appreciate ifanyone can help me to build a good formula for this problem. Thanks - 3. Match and Move Data in 2 Spreadsheets

I have 2 spreadsheets that have one column of data that is the same. I want to match that data and bring the corresponding data from another column into the first spreadsheet. - 4. View my templates with list as the default not icons.

When I open a new workbook in Excel 2007 and choose my templates, the default view is icons, with alternate choices of list, and details. Is it possible to change this default? - 5. anchor fields to pivot table (Excel 2007)

I have a pivot table that I create an IF statement against....to see if a field in the pivot table has any data in it. The pivot table has 10 rows in it...so my field with the IF statement has 10 rows....and the rows in my pivot table line up with the rows the IF statement is in. The problem is that if I change the selection for the pivot table that increases or decreases the number of rows in the pivot table...the pivot table rows and the rows in my IF statement don't line up any longer. How can I make my fields stay in line (on the same row) as the rows in my pivot table?-- Thanks, Jesse

### Next

### How do I only show decimal places if there are any?

by **YThkbnQ** » Fri, 01 Oct 2004 02:31:06 GMT

In Excel I only want to show 2 decimal places if the calculation is not a whole number. If the result is 99.00 in the field I want to show 99, if the result is 99.75 in the same field I want to show 99.75. Is there a way of doing this.I would be grateful for your help

Top

### Re: How do I only show decimal places if there are any?

by **Anne Troy** » Fri, 01 Oct 2004 02:36:24 GMT

Format the cells as General.**** Hope it helps! ****~DreamboatExcel VBA Certification Coming Soon!www.VBAExpress.com/training/********************************the

Top

### Re: How do I only show decimal places if there are any?

by **Dave Peterson** » Fri, 01 Oct 2004 09:10:29 GMT

But what about 99.75323423523?the OP could use a formula and a format of General:=round(existingformula,2)-- Dave Peterson XXXX@XXXXX.COM

Top

### Re: How do I only show decimal places if there are any?

by **YThkbnQ** » Sat, 02 Oct 2004 00:19:06 GMT

I have tried using general but it shows 99.75 as 99.8

Top

### Re: How do I only show decimal places if there are any?

by **YThkbnQ** » Sat, 02 Oct 2004 00:21:02 GMT

I have tried using general but it shows 99.75 as 99.8

Top

### Re: How do I only show decimal places if there are any?

by **Dave Peterson** » Sat, 02 Oct 2004 06:00:01 GMT

Widen the column a hair or two.-- Dave Peterson XXXX@XXXXX.COM

Top

### Re: How do I only show decimal places if there are any?

by **YThkbnQ** » Sat, 02 Oct 2004 16:13:03 GMT

Thanks Dave,I have widened the field but still have the problem which only occurs when the number is gets to 100 million: I was testing for maximums & I think it is unlikely to be a 100 million. I can live with that , although there does seem to be a problem in my version of Excel-Office 2003 if the value gets to this level.

Top

### Re: How do I only show decimal places if there are any?

by **Dave Peterson** » Sun, 03 Oct 2004 05:50:17 GMT

You have 100,000,000 in a cell and you're seeing ###'s????Do you have a formula in the cell? What formatting did you use?I don't think I've ever seen this happen when formatted as General.-- Dave Peterson XXXX@XXXXX.COM

Top

### Similar Threads:

1.Extra 1 showing up in 15th decimal place

2.Show Two Decimal Places After Concatenation

The value below is generated by a function. I used the "&" symbol to concatenate the "" with the value. Sometimes I use a "$" and sometimes I use a ". Now, I'm trying to show just two decimal places. 9506944.44444444Can someone please help out?TIA!!!

3.cell formated to 2 decimal places but excel shows it as 4 need 2

Formatting just changes the display of the number but does not change theunderlying value which can be many decimal places.You can use the ROUND function in your calculations.=ROUND(SUM(F1:F2),2)Alternative is to go to Tools>Options>Calculation and check "Precision asdisplayed".Note: this will permanently change all numbers on the sheet to displayedvalues.Gord Dibben MS Excel MVPOn Thu, 14 Dec 2006 11:18:02 -0800, b jones <b XXXX@XXXXX.COM >wrote:>i have the cell formated as 2 decimals but the cell information is in 4 to 5 >decimals i.e. 4.3453 need it to be 4.35 to be used for other functions how do >i get the cell in 2 decimals.

4.Decimal places showing up as Commas, not Periods

I'm running Office:Mac 2004For some reason, inputting '0.4' immediately resets to '0,4' (note thecomma) - as in France.(This doesn't show up in any other applications, with the exception ofIntuit QuickBooks)I've been running Office 2004 on this machine since it was released,and I had no such problems until very recently.I've tried:- talking to Apple Service about recent updates to the OS. Theyrecommended...- ...discarding preferences for Excel and Office and restarting. I'vedone this several times This helped by making the calculations work.When this first happened, I couldn't even calculate sums- checking and re-checking the 'International' settings on the Mac,which determine number and date formats. These are all set for the USA- combing through the Preferences and 'Format' settings in Excel,trying to find where I can reset things. I'm told that this is notdifficult in the PC version, but I can't find anything that works.Any help or suggestions would be deeply appreciated!- Caraway

5.Limit the number of decimal places shown when I merge Excel-Word

I want to limit the number of decimal places displayed on a Word document when I merge data from Excel into Word. This is testing information which includes a person'e weight. Instead of 168.2 it shows 168.1999999999. The weight was entered into the spreadsheet (as opposed to calculated). I have changed the number of decimal places to display in Excel and that makes no difference.

6. I am stupid and don't know what the heck I am doing wrong on t

7. I am doing a calculation in excel, I am multiplying a figure by a

8. Converting 2-place decimal value to floating point decimal number with leading zero

Post a reply

8 posts • Page **1** of **1**

Return to MS EXCEL

### Who is online

Users browsing this forum: No registered users and 91 guest

## FAQs

### How do I make Excel only show decimals? ›

Select a cell and type this formula **=A1-TRUNC(A1) (A1 is the cell you want to extract decimal value from) into the Formula Bar, and then press Enter key**. Keep selecting the first result cell, and drag fill handle down to get all results. You can see the decimal values are extracted with sign as below screenshot shown.

**How do you show decimals only when needed? ›**

**Just follow below steps:**

- Select the cell(s) where you want this formatting.
- Go to Conditional Formatting > New rule from home ribbon.
- Select rule type as “Use a formula…”
- Check if there is a value after decimal point using a formula like =Mod(A1,1)>0.
- Click the format button.

**How do I limit the number of decimal places? ›**

To decrease the number of decimal places, **select the cell with a number (here, B2), and in the Ribbon, go to Home > Decrease Decimal**. One click decreases the number of decimal places by one. As shown in the picture above, the number of decimal places in cell B2 is decreased to 5.

**How do I limit decimal places in Excel without rounding? ›**

To stop Excel from rounding whole numbers, **click the Increase Decimal button in the Home > Number tab.** **Increase the decimal place until the desired number of decimal places is displayed**.

**How do you show all decimals in sheets? ›**

**To apply a custom number format to your spreadsheet:**

- On your computer, open a spreadsheet in Google Sheets.
- Highlight the data you want to format.
- Click Format Number.
- Click Custom number format.
- Search in the menu text box to select a format. ...
- Click Apply.

**How do you show decimal representation? ›**

A rational number can be represented as a decimal number with the help of the long division method. We **divide the given rational number in the long division form and the quotient which we get is the decimal representation of the rational number**.

**How do you read decimals without whole numbers? ›**

Reading and Writing Decimal Numbers

If there are no whole numbers in front of the decimal value, you do not use the word “and”. Rather, you **read the number as normal and end with the last place value of the number**.

**How do I force a number to format in Excel? ›**

**Available number formats in Excel**

- Select a cell or a cell range.
- On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells… , and select Number. ...
- Select the format you want.

**How do I get Excel to only calculate 2 decimal places formula? ›**

For example: If you wanted to use the number from cell A2 and have it rounded to two decimal places, you could enter **=ROUND(A2,2)**.

**Can limit be in decimal? ›**

The answer is **a plain yes**.

### How do I limit significant figures in Excel? ›

For example, to round 2345678 down to 3 significant digits, you **use the ROUNDDOWN function with the parameter -4**, as follows: = ROUNDDOWN(2345678,-4). This rounds the number down to 2340000, with the "234" portion as the significant digits.

**How do you keep .00 in sheets? ›**

**Add or remove leading zeros in Excel and Google Sheets**

- Format as text to keep zeros as we type.
- Convert to text using TEXT and REPT function.
- Custom number format “0000000”

**Why is my excel not showing decimals? ›**

Click the File tab. Click on Options. In the Excel Options dialog box that opens up, click on the 'Advanced' option in the left pane. In the editing options, **enable the setting – “Automatically insert or decimal point”**

**What is a finite decimal? ›**

A finite decimal or terminating decimal is **a decimal representation of a number whose digits after decimals has an end**. e.g. 1/5 = 0.2.

**How do you show 3 decimal places? ›**

**The third decimal digit from the decimal point is the thousandths digit**. For example, 0.008 is eight thousandths. Read the whole set of three decimal digits as a number, and say “thousandths.” 0.825 has 8 tenths, 2 hundredths, and 5 thousandths.

**How do you read a place value with decimal points? ›**

**The first digit after the decimal represents the tenths place.** The next digit after the decimal represents the hundredths place. The remaining digits continue to fill in the place values until there are no digits left.

**How do I fix number format? ›**

The rectangular range between the active cell and the cell that you click becomes the new selection. To cancel a selection of cells, click any cell on the worksheet. **On the Home tab, in the Number group, click the Dialog Box Launcher next to Number.** **In the Category box, click the number format that you want to use**.

**How can we remove extra spaces from text? ›**

**Remove all spaces between numbers**

- Press Ctrl + Space to select all cells in a column.
- Press Ctrl + H to open the "Find & Replace" dialog box.
- Press Space bar in the Find What field and make sure the "Replace with" field is empty.
- Click on the "Replace all" button, and then press Ok. Voila! All spaces are removed.

**How do I get Excel to only calculate 3 decimal places formula? ›**

Round-off Formula in Excel - Round Up

The following method is used to round down ex: 3.14159 to three decimal places: **=ROUNDDOWN(3.14159,3)**, which will result in 3.141.

**Is there a limit to the number of decimal places in Excel? ›**

Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be **as large as 127**. If decimals is negative, number is rounded to the left of the decimal point.

### What is precise limit? ›

Precise Definition of Limit. Suppose f is a function. We say that **limx→af(x)=L lim x → a f ( x ) = L if for every ϵ>0 there is a δ>0 so that whenever 0<|x−a|<δ, 0 < | x − a | < δ , |f(x)−L|<ϵ**.

**How do I limit decimal places in Excel concatenate? ›**

To format a number rounded to a specified number of decimal places, **use the format string “#,##0.00”**. Each 0 is a number that must be displayed, even if it is zero. Each # is a number that can be displayed if there is a digit, but will be left out if there is no digit.

**How do you truncate significant figures? ›**

To truncate a number to 2 decimal places, miss off all the digits after the second decimal place. To truncate a number to 3 significant figures, **miss off all the digits after the first 3 significant figures (the first non-zero digit and the next two digits)**.

**Is there a way to limit the number of characters in a cell? ›**

In the Data Validation window, in the Settings tab, (1) choose Text length from the Allow drop down, then (2) select less than or equal to from the Data menu, and (3) enter a character limit for Maximum.

**How to restrict numeric value without decimal points in a cell from 1 to 99? ›**

**Limit cell entry to whole numbers or numbers in a given range**

- Select the range that you will set the numeric value entries, and click the Data > Data Validation. See screenshot:
- In the opening Data Validation dialog box, go to the Setting tab, and:
- (1) Select the Whole number item from the Allow drop down box.

**Is there a decimal function in Excel? ›**

**The DECIMAL Function[1] in Excel is a Math and Trigonometry function**. It is used for converting a text representation of a number in a stated base into a decimal value. The function was introduced in MS Excel 2013.

**How do I restrict a range of numbers in Excel? ›**

Select Data >Data Validation. On the Settings tab, under Allow, select an option: Whole Number - to restrict the cell to accept only whole numbers. Decimal - to restrict the cell to accept only decimal numbers.

**How do I remove excess decimals in Excel? ›**

You can use the formula **=INT(E2*10)/10** to delete all digits following the decimal save the first one. In a blank cell besides the value you will remove digits after decimal, enter the formula =INT(E2), and the drag the Fill Handle to the range you need.

**How do you restrict inputs to only numbers? ›**

We use the **<input type="number">** to limit an HTML input box so that it only accepts numeric inputs. By using this, we will get a numeric input field.

**What are the two types of decimals in Excel? ›**

**There are two types of Decimals**

- Non recurring decimal or terminating decimal.
- Recurring decimal or non terminating decimal.

### How can you format in cell with decimal values? ›

**Available number formats in Excel**

- Select a cell or a cell range.
- On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells… , and select Number. ...
- Select the format you want.

**What is decimal separator in Excel? ›**

**The decimal point (.) or comma (,)** is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.