Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Limit decimal places in a string cell reference
I am referencing a cell which has 1 decimal place yet it shows about 12
places right of the decimal in the string. What am I doing wrong? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Limit decimal places in a string cell reference
Use this:
=TEXT(A1,"0.0") or something like this: ="Result is: "&TEXT(A1,"0.0") Hope this helps. Pete On Dec 29, 2:41*pm, Ozinus wrote: I am referencing a cell which has 1 decimal place yet it shows about 12 places right of the decimal in the string. What am I doing wrong? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Limit decimal places in a string cell reference
The cell DOING the referencing isn't formatted properly. CTRL+1 will open the format box. You need to be careful with references, your problem shows how data can LOOK one way but actually be another. The cell you're referencing appears to have a long calculated value in it with many decimal places. It is formatted to only show 1 decimal place...which is usually OK. But if you start doing calculations against that cell, you'll start to notice discrepancies in the resulting math. That's because the number is really much longer than you're seeing. To eliminate the discrepancy, you need to round off those values properly. Look at the help files on ROUND and MROUND. You can do the rounding in the cell itself or in the cells that reference that cell, just remember to do it. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44794 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Limit decimal places in a string cell reference
Either
a) format the cell to display only 1 decimal place or b) use a formula such as =ROUND(A1,1) to round the actual stored value to one decimal place best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ozinus" wrote in message ... I am referencing a cell which has 1 decimal place yet it shows about 12 places right of the decimal in the string. What am I doing wrong? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Limit decimal places in a string cell reference
Another way is to use FIXED function, i.e.
=FIXED(A1,1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Swallows Decimal Places | Excel Discussion (Misc queries) | |||
appended a cell, but need to keep decimal places | Excel Discussion (Misc queries) | |||
decimal places in format cell | Excel Discussion (Misc queries) | |||
How many decimal places can a cell display? | Excel Worksheet Functions | |||
How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions |