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 Use actual number displayed?
I'm working on a spreadsheet with a lot of referenced formulas. I have it set to where, for example, .08*19 displays the answer "2" because I have it with no decimal places. But when I go to reference this cell in another formula, I can't get it to use "2", it uses the actual value which is 1.52, even though 2 is shown. I need it to use the value shown in the calculation. Any idea of how I can get this to use the displayed value? Thanks -- BrandenKilgore ------------------------------------------------------------------------ BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145 View this thread: http://www.excelforum.com/showthread...hreadid=394730 |
#2
|
|||
|
|||
Either include a ROUND() function in the cell where .08*19 is located, or in
the formula that references this cell. For example, if the .08*19 value is stored in A1, you would write: =ROUND(A1,0) instead of just calling A1 -- David Billigmeier "BrandenKilgore" wrote: I'm working on a spreadsheet with a lot of referenced formulas. I have it set to where, for example, .08*19 displays the answer "2" because I have it with no decimal places. But when I go to reference this cell in another formula, I can't get it to use "2", it uses the actual value which is 1.52, even though 2 is shown. I need it to use the value shown in the calculation. Any idea of how I can get this to use the displayed value? Thanks -- BrandenKilgore ------------------------------------------------------------------------ BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145 View this thread: http://www.excelforum.com/showthread...hreadid=394730 |
#3
|
|||
|
|||
BrandenKilgore,
Use Tools / Options.... Calculation tab, check "Precision as displayed" HTH, Bernie MS Excel MVP "BrandenKilgore" BrandenKilgore.1tke6z_1123704354.3178@excelforu m-nospam.com wrote in message news:BrandenKilgore.1tke6z_1123704354.3178@excelfo rum-nospam.com... I'm working on a spreadsheet with a lot of referenced formulas. I have it set to where, for example, .08*19 displays the answer "2" because I have it with no decimal places. But when I go to reference this cell in another formula, I can't get it to use "2", it uses the actual value which is 1.52, even though 2 is shown. I need it to use the value shown in the calculation. Any idea of how I can get this to use the displayed value? Thanks -- BrandenKilgore ------------------------------------------------------------------------ BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145 View this thread: http://www.excelforum.com/showthread...hreadid=394730 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How could the number, '102845678' be displayed as '10,28,45,678'? | vnranand | General Discussion | 6 | May 17th, 2006 07:29 AM |
Can I remove the "page and number" displayed on Excel spreadsheet | Janice Jackson | General Discussion | 1 | August 17th, 2005 06:06 PM |
How to change the format of a displayed number in a form | Darrell Childress | Using Forms | 1 | May 31st, 2005 02:47 PM |
Field in Table | LMB | New Users | 14 | October 11th, 2004 07:13 AM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |