| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying values
Suppose sheet1.A1 has value 0.00 displayed on worksheet. Hoewever, the value
"0" is stored in the formula box. When I execute the code below, it displays "0" on sheet2.A1 instead of 0.00. How can I make this operation give me 0.00? sheet2.cells(1,1).value = sheet1.cells(1,1).value |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying only the numerical values | New Users to Excel | |||
| Copying Cell Values | Excel Discussion (Misc queries) | |||
| Copying Values to another Workbook | Excel Programming | |||
| Copying values from one file to another | Excel Programming | |||
| copying values | Excel Programming | |||
Threaded Mode
