Range values not being copied with same number of significant digits

[Barb Reinhardt]

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

 

[Barb Reinhardt]

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]

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.

 

[Niek Otten]

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



| 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

 

[Barb Reinhardt]

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