rambabu304 Posted May 9, 2012 Report Share Posted May 9, 2012 okka cell lo $0.9290 vundi.... its actual value is $0.9289665874590. you see this in the display bar....... what I want to do is....i want to keep only 4 digits after the decimal ( $0.9290) and remove all the other digits and you should only see $0.9290 in the display bar when you click it........... help cheyandi mamallu... google ella search kotalloo teliyadam ledu........ Link to comment Share on other sites More sharing options...
Vaampire Posted May 9, 2012 Report Share Posted May 9, 2012 cell ni select chesukoni. right click chesthey format aney option untadhi. daantlo vethuku Link to comment Share on other sites More sharing options...
taadu.....bongaram Posted May 9, 2012 Report Share Posted May 9, 2012 Display lo change cheya vachu kaani Bar lo ante kastam emo..... mee freinds evaranna QA kaani SA ga work cheste vaallani adugu baaga idea vuntundi Link to comment Share on other sites More sharing options...
pinky123 Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='rambabu304' timestamp='1336524708' post='1301759329'] okka cell lo $0.9290 vundi.... its actual value is $0.9289665874590. you see this in the display bar....... what I want to do is....i want to keep only 4 digits after the decimal ( $0.9290) and remove all the other digits and you should only see $0.9290 in the display bar when you click it........... help cheyandi mamallu... google ella search kotalloo teliyadam ledu........ [/quote] if the original value is in A1 try using the formula "=round(a1,4)" in the cell adjacent to it......then copy this cell and do a paste special in the next cell...... you can avoid the last step but you will see the formula in the display bar and not the value Link to comment Share on other sites More sharing options...
mtkr Posted May 9, 2012 Report Share Posted May 9, 2012 ante file motham original value 4 decimal digits ki truncate aipovaaliiii anthe naa!!! Link to comment Share on other sites More sharing options...
Jatka Bandi Posted May 9, 2012 Report Share Posted May 9, 2012 cell/column ni select chesukuni right click chesi.... format cells click chey... next number tab kinda number select chesukuni number of digits to display select chesuko.... idi help lo kottina google chesina vachundedi.... thread bokka.... Link to comment Share on other sites More sharing options...
riddle Posted May 9, 2012 Report Share Posted May 9, 2012 [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx[/url] [list] [*]Select the cell or [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]range[/url] of cells that contains the numbers for which you want to change the decimal places. [/list][color=#454545][font=Arial, Verdana][size=3] [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"][img]http://officeimg.vo.msecnd.net/en-us/files/785/945/ZA079005000.gif[/img]How to select a cell or a range[/url][/size][/font][/color][list] [*]On the [b]Formatting[/b] [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]toolbar[/url], do one of the following: [list] [*]Click [b]Increase Decimal[/b] [img]http://officeimg.vo.msecnd.net/en-us/files/475/281/ZA006045002.gif[/img] to display more digits after the decimal point. [*]Click [b]Decrease Decimal[/b] [img]http://officeimg.vo.msecnd.net/en-us/files/038/134/ZA006045003.gif[/img] to display fewer digits after the decimal point. [/list] [/list] Link to comment Share on other sites More sharing options...
rambabu304 Posted May 9, 2012 Author Report Share Posted May 9, 2012 [quote name='Vaampire' timestamp='1336524800' post='1301759339'] cell ni select chesukoni. right click chesthey format aney option untadhi. daantlo vethuku [/quote] ledu bro.. adi only neeku rounding options isthadi....but still in the display bar it gives u all the digits.... what i want to do is completely convert it into only 4 digits after decimal Link to comment Share on other sites More sharing options...
Jatka Bandi Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='pinky123' timestamp='1336524944' post='1301759351'] if the original value is in A1 try using the formula "=round(a1,4)" in the cell adjacent to it......then copy this cell and do a paste special in the next cell...... you can avoid the last step but you will see the formula in the display bar and not the value [/quote] another method Link to comment Share on other sites More sharing options...
ToughGuy Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='pinky123' timestamp='1336524944' post='1301759351'] if the original value is in A1 try using the formula "=round(a1,4)" in the cell adjacent to it......then copy this cell and do a paste special in the next cell...... you can avoid the last step but you will see the formula in the display bar and not the value [/quote] [quote name='riddle' timestamp='1336525037' post='1301759364'] [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]http://office.micros...P005241206.aspx[/url] [list] [*]Select the cell or [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]range[/url] of cells that contains the numbers for which you want to change the decimal places. [/list] [color=#454545][font=Arial, Verdana][size=3][url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"][img]http://officeimg.vo.msecnd.net/en-us/files/785/945/ZA079005000.gif[/img]How to select a cell or a range[/url][/size][/font][/color][list] [*]On the [b]Formatting[/b] [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]toolbar[/url], do one of the following: [list] [*]Click [b]Increase Decimal[/b] [img]http://officeimg.vo.msecnd.net/en-us/files/475/281/ZA006045002.gif[/img] to display more digits after the decimal point. [*]Click [b]Decrease Decimal[/b] [img]http://officeimg.vo.msecnd.net/en-us/files/038/134/ZA006045003.gif[/img] to display fewer digits after the decimal point. [/list] [/list] [/quote] good post Link to comment Share on other sites More sharing options...
mtkr Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='riddle' timestamp='1336525037' post='1301759364'] [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]http://office.micros...P005241206.aspx[/url] [list] [*]Select the cell or [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]range[/url] of cells that contains the numbers for which you want to change the decimal places. [/list] [color=#454545][font=Arial, Verdana][size=3][url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"][img]http://officeimg.vo.msecnd.net/en-us/files/785/945/ZA079005000.gif[/img]How to select a cell or a range[/url][/size][/font][/color][list] [*]On the [b]Formatting[/b] [url="http://office.microsoft.com/en-us/excel-help/change-the-number-of-decimal-places-displayed-HP005241206.aspx"]toolbar[/url], do one of the following: [list] [*]Click [b]Increase Decimal[/b] [img]http://officeimg.vo.msecnd.net/en-us/files/475/281/ZA006045002.gif[/img] to display more digits after the decimal point. [*]Click [b]Decrease Decimal[/b] [img]http://officeimg.vo.msecnd.net/en-us/files/038/134/ZA006045003.gif[/img] to display fewer digits after the decimal point. [/list] [/list] [/quote] ila chesthe kuda display maaradhu anukunta kada bayyaa... Link to comment Share on other sites More sharing options...
Gold_raja Posted May 9, 2012 Report Share Posted May 9, 2012 [img]http://www.functionx.com/excel/images/excel1.gif[/img] mama ee image lo.... 'general' kinda... "$" symbol undi kada.... daani kinda unna two buttons used to edit number of decimal digits... and rounding off. Link to comment Share on other sites More sharing options...
riddle Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='mtkr' timestamp='1336525356' post='1301759399'] ila chesthe kuda display maaradhu anukunta kada bayyaa... [/quote] maruthundhi bhayya.. increase decrease decimal adhi. nenu adhe use chesta general ga.. Link to comment Share on other sites More sharing options...
riddle Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='pinky123' timestamp='1336524944' post='1301759351'] if the original value is in A1 try using the formula "=round(a1,4)" in the cell adjacent to it......then copy this cell and do a paste special in the next cell...... you can avoid the last step but you will see the formula in the display bar and not the value [/quote] intha chinna daniki formula lu rayala [url=http://www.desigifs.com/gifs/1628/brahmanandam][img]http://www.desigifs.com/sites/default/files/bemmi.surprise.gif[/img][/url] Link to comment Share on other sites More sharing options...
pinky123 Posted May 9, 2012 Report Share Posted May 9, 2012 [quote name='Gold_raja' timestamp='1336525442' post='1301759417'] [img]http://www.functionx.com/excel/images/excel1.gif[/img] mama ee image lo.... 'general' kinda... "$" symbol undi kada.... daani kinda unna two buttons used to edit number of decimal digits... and rounding off. [/quote] ila chesina... display bar lo original number kanipistundi and not the round off number Link to comment Share on other sites More sharing options...
.thumb.jpg.abf7d08f99d33f7507f9f0e982085cc3.jpg)
Recommended Posts