Excel Help

[charygaru]

[quote name='Murthygaru' timestamp='1350052463' post='1302617111']
also i feel like the data is not improted properly ..number kinda date ani kooda untundi adi kooda chesko for the second column
[/quote]

anni rakalu ga format chesthe ne second pic lo laaga ochhindi ra kani ala naaku kavalsina vidham ga fgormat chesakja save antadi save as ani malla first pic lo unna vidhamga save chesthundi but why ani ardham aythale

[krisomania2043]

[quote name='charygaru' timestamp='1350052531' post='1302617118']
oh decimals ni teseyachha nice kaani save chesaka osthaledu bay atla malla biskit ayyipothudni and also i want 0 in the first four places in the first claim ids ye rakam ga format chesina aa zeros ni display chesthaledu deenamma excell
[/quote]
excel ;o Home tab lo 4th block lo GENERAL ani oka drop down undi $ % ila untadi dani pakkana <--- .0 , .00---> ila rendu buttons untayi vatini pettukunte 0 vasthayi
else
excel lo automatic ga 0 ni stike off chestundi daniki
0 mundu
'0000012345
ila pettuko
vastundi

[chittimallu4]

[quote name='qualityposter' timestamp='1350052547' post='1302617120']

endhi nuvvu kooda gif lu vesthunava
[/quote]indhake dalapathi thread lo kottesa [img]http://www.desigifs.com/sites/default/files/brahmam_fanski.gif?1290059152[/img]

[jaffanajeffada]

[quote name='jaffanajeffada' timestamp='1350052171' post='1302617079']
copy chese mundhu, motham anni cells select chesi, right click -> format cells -> Under category select text -> then paste
[/quote]

did you try this?

[krisomania2043]

[quote name='charygaru' timestamp='1350052598' post='1302617127']
anni rakalu ga format chesthe ne second pic lo laaga ochhindi ra kani ala naaku kavalsina vidham ga fgormat chesakja save antadi save as ani malla first pic lo unna vidhamga save chesthundi but why ani ardham aythale
[/quote]
sql result set ni improt cheskunetappudu RAW IMPORT CHEY
options lo TEXT ani select cheskuni import chekune option unda choodu

[charygaru]

[quote name='padmasri123' timestamp='1350052230' post='1302617088']

Clarity ledu dates 00:00;000 ani undi forst dantlo ,second dantlo dates unnay y re?
[/quote]

,aa sql la date is yyyy-dd-mm 00:00:00 format mama anduke import chesthe atla osthuindi anukunta kaani nenu save chesina csv file ni ila marchukuntunna second pic lo laaga but it is not saving like that ade enduko ardham aythaleduy

[padmasri123]

[quote name='charygaru' timestamp='1350052598' post='1302617127']
anni rakalu ga format chesthe ne second pic lo laaga ochhindi ra kani ala naaku kavalsina vidham ga fgormat chesakja save antadi save as ani malla first pic lo unna vidhamga save chesthundi but why ani ardham aythale
[/quote]

Chary go and save it to a new Excel Work book ..it remains as you need..

[innovative]

[quote name='charygaru' timestamp='1350052598' post='1302617127']
anni rakalu ga format chesthe ne second pic lo laaga ochhindi ra kani ala naaku kavalsina vidham ga fgormat chesakja save antadi save as ani malla first pic lo unna vidhamga save chesthundi but why ani ardham aythale
[/quote]
quick thought .. save cheyyakuda .. save as option use chesi choodandi .. appudu meeku nachina format select cheyochu kada

[jaffanajeffada]

[quote name='charygaru' timestamp='1350052750' post='1302617148']
,aa sql la date is yyyy-dd-mm 00:00:00 format mama anduke import chesthe atla osthuindi anukunta kaani nenu save chesina csv file ni ila marchukuntunna second pic lo laaga but it is not saving like that ade enduko ardham aythaleduy
[/quote]
if you open a CSV in excel and format that in excel and if you save it again as CSV, it will not hold the formatting.

[charygaru]

[quote name='Murthygaru' timestamp='1350052677' post='1302617138']
excel ;o Home tab lo 4th block lo GENERAL ani oka drop down undi $ % ila untadi dani pakkana <--- .0 , .00---> ila rendu buttons untayi vatini pettukunte 0 vasthayi
else
excel lo automatic ga 0 ni stike off chestundi daniki
0 mundu
'0000012345
ila pettuko
vastundi
[/quote]

atla chesthe back lo 00 add aythunnai ra naaku mundu kaaavaali

[charygaru]

[quote name='jaffanajeffada' timestamp='1350052726' post='1302617145']
did you try this?
[/quote]

will do and let u mama wait.

mama adi chesa kaani ala chesthe doi you wanrt to save changes ani cheppi unicode lo save chesuko antundi which is not opening later on

[chelsea]

Chary garu lekapothe Excel lo data ane tab vunntadi akkada ki velli from other sources -> sqlserver --connection ichi query isthe automatic ga data vasthadi

[krisomania2043]

[quote name='charygaru' timestamp='1350052880' post='1302617167']
atla chesthe back lo 00 add aythunnai ra naaku mundu kaaavaali
[/quote]
'00012345
idi try chey

[padmasri123]

[quote name='charygaru' timestamp='1350052901' post='1302617171']
will do and let u mama wait.

mama adi chesa kaani ala chesthe doi you wanrt to save changes ani cheppi unicode lo save chesuko antundi which is not opening later on
[/quote]


Chary garu meeru format antha ipoyaka...go to home and save it to a new excel work book and give a name to that file...

[charygaru]

[quote name='chelsea' timestamp='1350052939' post='1302617175']
Chary garu lekapothe Excel lo data ane tab vunntadi akkada ki velli from other sources -> sqlserver --connection ichi query isthe automatic ga data vasthadi
[/quote]

anni bagane unnai mama query ekkada iyyaloi ardham auythale