| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news  648189E-8645-4555-B37E-(E-Mail Removed)...> 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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" <(E-Mail Removed)> wrote in message > news 648189E-8645-4555-B37E-(E-Mail Removed)...>> 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 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> 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" <(E-Mail Removed)> wrote in message >> news 648189E-8645-4555-B37E-(E-Mail Removed)...>>> 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 >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
How many of us are there? <g>
Gord On Fri, 14 May 2010 17:50:41 -0400, "JLGWhiz" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message >news:(E-Mail Removed)... >> 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" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> 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" <(E-Mail Removed)> wrote in message >>> news 648189E-8645-4555-B37E-(E-Mail Removed)...>>>> 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 >>> >>> > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to: copy value from active sheet to all other sheets with VBA (in desired cell) | DVAL | Microsoft Excel Programming | 3 | 15th Dec 2010 01:38 AM |
| Copy worksheet1 to worksheet2, keep cell format eg cell size | slocookie | Microsoft Excel Misc | 2 | 8th Jan 2010 11:24 AM |
| Lock Cell Format - Allow copy and paste of data without format change | Chris12InKC | Microsoft Excel Worksheet Functions | 1 | 11th Mar 2006 04:44 AM |
| How do I copy data in single cell format to a merged cell format | =?Utf-8?B?UGF1bA==?= | Microsoft Excel Misc | 1 | 27th Jun 2005 11:00 AM |
| How to get desired format in textbox linked to a cell | NoSpam@aol.com | Microsoft Excel Programming | 3 | 14th Jan 2004 02:05 PM |
