Calling Excel Guru's

[rambabu304]

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]

cell ni select chesukoni. right click chesthey format aney option untadhi. daantlo vethuku

[taadu.....bongaram]

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]

[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]

ante file motham original value 4 decimal digits ki truncate aipovaaliiii anthe naa!!!

[Jatka Bandi]

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]

[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]

[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]

[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]

[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]

[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]

[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]

[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]

[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]

[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