Range values not being copied with same number of significant digits
 

I'm trying to copy the values from one worksheet to another and I'm
finding that the values that are displayed are what's copied, rather
than the full value in the cell. How do I get the entire value?

Also, does anyone know the status of the Microsoft interface.

Thanks,
Barb Reinhardt

Range values not being copied with same number of significantdigits
 

I probably should have said that I have code similar to this

aws.range("Range").value = ows.range("Range").value

The range is one cell. Let's say the displayed value on the oWS is
1.32, but the value when the cell is selected is 1.320102.

Barb

Range values not being copied with same number of significant digits
 

Maybe you can widen the column to see all the digits.

I'm confused about what you're selecting and what you're viewing...

If you're selecting the range on the aws worksheet and looking at the
formulabar, what do you see?

If you see the 1.320102, try widening the column or changing the numberformat of
the cell to what you want.

If you're selecting the ows range and see 1.320102 in the formulabar, but see
1.32 in the formulabar when you select the aws range, then I bet it's the format
of the original cell that's screwing you up.

Try:

aws.range("Range").value2 = ows.range("Range").value2

VBA's help for .value2 explains when .value can cause trouble.

Barb Reinhardt wrote:

I probably should have said that I have code similar to this

aws.range("Range").value = ows.range("Range").value

The range is one cell. Let's say the displayed value on the oWS is
1.32, but the value when the cell is selected is 1.320102.

Barb

--

Dave Peterson

Range values not being copied with same number of significant digits
 

Hi Barb,

I can only reproduce this result using

[a2].value=[a1].text

But do check the replies you got from Dave

<the status of the Microsoft interface

I guess you refer to the Ribbon, but I'm not sure. Can you elaborate on what your question is?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"Barb Reinhardt" wrote in message
...
| I'm trying to copy the values from one worksheet to another and I'm
| finding that the values that are displayed are what's copied, rather
| than the full value in the cell. How do I get the entire value?
|
| Also, does anyone know the status of the Microsoft interface.
|
| Thanks,
| Barb Reinhardt

Range values not being copied with same number of significantdigits
 

I mean the Microsoft Web Interface for the newsgroup. That's how I
usually access it, but it doesn't seem to work.

On Jan 16, 1:03*pm, "Niek Otten" wrote:
Hi Barb,

I can only reproduce this result using

[a2].value=[a1].text

But do check the replies you got from Dave

<the status of the Microsoft interface

I guess you refer to the Ribbon, but I'm not sure. Can you elaborate on what your question is?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Barb Reinhardt" wrote in message

...
| I'm trying to copy the values from one worksheet to another and I'm
| finding that the values that are displayed are what's copied, rather
| than the full value in the cell. *How do I get the entire value?
|
| Also, does anyone know the status of the Microsoft interface.
|
| Thanks,
| Barb Reinhardt