| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format Changes During VBA Copy/Paste
I have an Excel workbook with VBA code that copies a series of numeric values
from sheet 2 and pastes them into corresponding cells in sheet 1. In one case, the value in sheet 2 is 0.0170, but when pasted into sheet 1 it displays as 0.0200. Both cell formats appear to be identical, there's no rounding going on in the VBA, so can't for the life of me figure out why this is happening. Anyone have an idea? (Excel 2007 on Windows XP Pro) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| copy / paste format | Excel Worksheet Functions | |||
| Copy and Paste in certain format | Excel Worksheet Functions | |||
| format changes after copy/paste | Excel Discussion (Misc queries) | |||
| Copy and Paste and keep format the same | Excel Discussion (Misc queries) | |||
Threaded Mode
