Calling Excel Guru's

[riddle]

[quote name='bantrothu bullabbai' timestamp='1336525074' post='1301759367']
another method

[/quote]

[url=http://www.desigifs.com/gifs/1656/brahmanandam][img]http://www.desigifs.com/sites/default/files/Brahmi-2.gif[/img][/url]

[mtkr]

[quote name='riddle' timestamp='1336525543' post='1301759432']

maruthundhi bhayya.. increase decrease decimal adhi. nenu adhe use chesta general ga..
[/quote]
cell lo value change avutundhi..... kani a cel ni click chesi display bar lo chusthe original value e chupistundhi kada abyyaa!!!!

[riddle]

[quote name='pinky123' timestamp='1336525634' post='1301759448']


ila chesina... display bar lo original number kanipistundi and not the round off number
[/quote]

[url=http://www.desigifs.com/gifs/391/pawan-kalyan][img]http://www.desigifs.com/sites/default/files/ahh.gif[/img][/url] agreed.. ippude chusa.. but display bar lo emi unte enti.. page lo kanpadidhe kavali kadha

[pinky123]

[quote name='riddle' timestamp='1336525605' post='1301759441']

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

ante paina display bar lo kuda round off chesina number kanipinchali ante direct ga we have to use this formula

[riddle]

[quote name='mtkr' timestamp='1336525718' post='1301759463']
cell lo value change avutundhi..... kani a cel ni click chesi display bar lo chusthe original value e chupistundhi kada abyyaa!!!!
[/quote]

ya ippude chusa bhayya.. u r right but display bar lo kanapadakudadha..but cell lo unnadhe kadha overall ga chustaru but requirement display bar ayithe vere options chudali emo..

[riddle]

[quote name='pinky123' timestamp='1336525746' post='1301759467']

ante paina display bar lo kuda round off chesina number kanipinchali ante direct ga we have to use this formula
[/quote]


hi pinky ela unnavu..

naaku programming alantivi asalu touch ledhu... formula lu ante [url=http://www.desigifs.com/gifs/789/venkatesh][img]http://www.desigifs.com/sites/default/files/venky2.gif[/img][/url]

[pinky123]

[quote name='riddle' timestamp='1336525879' post='1301759487']


hi pinky ela unnavu..

naaku programming alantivi asalu touch ledhu... formula lu ante [url="http://www.desigifs.com/gifs/789/venkatesh"][img]http://www.desigifs.com/sites/default/files/venky2.gif[/img][/url]
[/quote]

nenu bagunna... nuvvu ela unnavu? aasalu DB ki ravadam ledu ga nuvvu.. but y

[mtkr]

[quote name='riddle' timestamp='1336525807' post='1301759475']

ya ippude chusa bhayya.. u r right but display bar lo kanapadakudadha..but cell lo unnadhe kadha overall ga chustaru but requirement display bar ayithe vere options chudali emo..
[/quote]
yaa... req ala undhi emoo.... kontha mandhi fakodi gaaluu untaru gaa...

[rambabu304]

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

Thanks a lot... this worked....... naa pani okka 5 mins lo ayyipoyindi.......... thanks a lot,,,,,,,,,,

[riddle]

[quote name='pinky123' timestamp='1336525952' post='1301759494']

nenu bagunna... nuvvu ela unnavu? aasalu DB ki ravadam ledu ga nuvvu.. but y
[/quote]

nenu kuda baane unna...

asalu office lo water thagataniki kuda time undatla.. chaala stressfull ga untandhi [url=http://www.desigifs.com/gifs/1120/brahmanandam][img]http://www.desigifs.com/sites/default/files/brahmam_style2_0.gif[/img][/url] andhuke DB login avalekapothunna

nee job ela undhi..

[rambabu304]

thanks guys for all your replies............

mee aandariki ee song dedicate chesthuna.. pinky ki spl ga.......

[url="http://www.youtube.com/watch?v=IxoCUHJwJjc"]http://www.youtube.com/watch?v=IxoCUHJwJjc[/url]

[rambabu304]

[quote name='riddle' timestamp='1336525807' post='1301759475']

ya ippude chusa bhayya.. u r right but display bar lo kanapadakudadha..but cell lo unnadhe kadha overall ga chustaru but requirement display bar ayithe vere options chudali emo..
[/quote]

a cell ni vere cell tho compare cheyali bhaya..... so ani digits vuntey it is not equalling the other cell so had to remove the extra decimals.......

[riddle]

[quote name='rambabu304' timestamp='1336526962' post='1301759563']
a cell ni vere cell tho compare cheyali bhaya..... so ani digits vuntey it is not equalling the other cell so had to remove the extra decimals.......
[/quote]

got u bhayya.. ardham ayindhi

[pinky123]

[quote name='riddle' timestamp='1336526198' post='1301759517']

nenu kuda baane unna...

asalu office lo water thagataniki kuda time undatla.. chaala stressfull ga untandhi [url="http://www.desigifs.com/gifs/1120/brahmanandam"][img]http://www.desigifs.com/sites/default/files/brahmam_style2_0.gif[/img][/url] andhuke DB login avalekapothunna

nee job ela undhi..
[/quote]

ok bagane undi kani.... 5 members cheyalsi panini iddariki ichi champestunnaru...

[pinky123]

[quote name='rambabu304' timestamp='1336526341' post='1301759525']
thanks guys for all your replies............

mee aandariki ee song dedicate chesthuna.. pinky ki spl ga.......

[media]http://www.youtube.com/watch?v=IxoCUHJwJjc[/media]
[/quote]