copy a from a cell to another with desired format
in [Programming]
|
From: JLGWhiz on 14 May 2010 17:50 No, that is just the stupid in me that shows up now and then. I have no idea what I was thinking. But I can always blame it on senility. "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message news:uffkEp68KHA.5900(a)TK2MSFTNGP04.phx.gbl... > You accidentally encased your string expression in a CDbl function call; I > believe you meant to post this... > > aWS.Range("L80").NumberFormat = "#,##0.0000" > > -- > Rick (MVP - Excel) > > > > "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message > news:OjddOZ68KHA.1436(a)TK2MSFTNGP06.phx.gbl... >> Assuming you want numeric: >> >> aWS.Range("L80").Value = aWS.Range("J80").Value >> aWS.Range("L80").NumberFormat = CDbl("#,##0.0000") >> >> But Excel will clip all zeros on the right of any digit of value. >> >> >> "pls123" <pls123(a)discussions.microsoft.com> wrote in message >> news:D648189E-8645-4555-B37E-1ED62643B1F6(a)microsoft.com... >>> hi all i need to make this copy.. >>> >>> aWS.Range("L80").Value = aWS.Range("J80").Value >>> >>> but with format with 4 decimals... >>> can anybody help ? >>> tx! paolo >> >>
From: JLGWhiz on 14 May 2010 17:57 Most of this stuff is in the VBE help files, in case the MS server goes down. "USH" <USH(a)discussions.microsoft.com> wrote in message news:8DEC3A58-C37F-444F-8D45-A93066EEA90A(a)microsoft.com... > tx !! > and if i want format as hour ?? > > HH.MM.SS ?? > > > > > "Gary''s Student" wrote: > >> Sub dural() >> Set aWS = ActiveSheet >> aWS.Range("L80").Value = aWS.Range("J80").Value >> aWS.Range("L80").NumberFormat = "0.0000" >> End Sub >> >> -- >> Gary''s Student - gsnu201003
From: Gord Dibben on 14 May 2010 18:10
How many of us are there? <g> Gord On Fri, 14 May 2010 17:50:41 -0400, "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote: >No, that is just the stupid in me that shows up now and then. I have no >idea what I was thinking. But I can always blame it on senility. > > >"Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message >news:uffkEp68KHA.5900(a)TK2MSFTNGP04.phx.gbl... >> You accidentally encased your string expression in a CDbl function call; I >> believe you meant to post this... >> >> aWS.Range("L80").NumberFormat = "#,##0.0000" >> >> -- >> Rick (MVP - Excel) >> >> >> >> "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message >> news:OjddOZ68KHA.1436(a)TK2MSFTNGP06.phx.gbl... >>> Assuming you want numeric: >>> >>> aWS.Range("L80").Value = aWS.Range("J80").Value >>> aWS.Range("L80").NumberFormat = CDbl("#,##0.0000") >>> >>> But Excel will clip all zeros on the right of any digit of value. >>> >>> >>> "pls123" <pls123(a)discussions.microsoft.com> wrote in message >>> news:D648189E-8645-4555-B37E-1ED62643B1F6(a)microsoft.com... >>>> hi all i need to make this copy.. >>>> >>>> aWS.Range("L80").Value = aWS.Range("J80").Value >>>> >>>> but with format with 4 decimals... >>>> can anybody help ? >>>> tx! paolo >>> >>> > |