rambabu304 Posted May 9, 2012 Report 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........
Vaampire Posted May 9, 2012 Report Posted May 9, 2012 cell ni select chesukoni. right click chesthey format aney option untadhi. daantlo vethuku
taadu.....bongaram Posted May 9, 2012 Report 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
pinky123 Posted May 9, 2012 Report 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
mtkr Posted May 9, 2012 Report Posted May 9, 2012 ante file motham original value 4 decimal digits ki truncate aipovaaliiii anthe naa!!!
Jatka Bandi Posted May 9, 2012 Report 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....
riddle Posted May 9, 2012 Report 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]
rambabu304 Posted May 9, 2012 Author Report 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
Jatka Bandi Posted May 9, 2012 Report 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
ToughGuy Posted May 9, 2012 Report 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
mtkr Posted May 9, 2012 Report 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...
Gold_raja Posted May 9, 2012 Report 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.
riddle Posted May 9, 2012 Report 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..
riddle Posted May 9, 2012 Report 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]
pinky123 Posted May 9, 2012 Report 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
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts