Thread: Copy & Paste value Function

When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
points. Meaning it will post the value for example xx.xxxxxx. Is there a way
that I can paste the value by two decimal points only. Again for example
xx.xx instead of xx.xxxxxx.

Thanks in advance for the solution.

DS

Just pre-format the cell(s)

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
news:7432BE46-74B1-4AC3-BF67-09DF4848B892@microsoft.com...
> When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
> points. Meaning it will post the value for example xx.xxxxxx. Is there a
> way
> that I can paste the value by two decimal points only. Again for example
> xx.xx instead of xx.xxxxxx.
>
> Thanks in advance for the solution.
>
> DS

Paste Values does exactly what it says on the tin and only pastes values.
This means that your data will take on whatever format the cell has, so if
it hasn't been formatted as anything before it will default to general and
you will get a load of decimals as you are seeing.

I'm guessing that what you really want to do is simply do it twice, paste as
normal which will likely give you garbage data but the correct formats, and
then do paste special as values and you get the best of both worlds.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
news:7432BE46-74B1-4AC3-BF67-09DF4848B892@microsoft.com...
> When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
> points. Meaning it will post the value for example xx.xxxxxx. Is there a
> way
> that I can paste the value by two decimal points only. Again for example
> xx.xx instead of xx.xxxxxx.
>
> Thanks in advance for the solution.
>
> DS

Hi don, After formatting, visibly there are only two decimals, but when you
click on the cell, it has more than two decimals. How do I truncate the more
than two deicmal points?

"Don Guillett" wrote:

> Just pre-format the cell(s)
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
> news:7432BE46-74B1-4AC3-BF67-09DF4848B892@microsoft.com...
> > When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
> > points. Meaning it will post the value for example xx.xxxxxx. Is there a
> > way
> > that I can paste the value by two decimal points only. Again for example
> > xx.xx instead of xx.xxxxxx.
> >
> > Thanks in advance for the solution.
> >
> > DS
>
>
>

You can use precision as displayed under tools>options>calculation


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
news:621A4AFE-9754-430D-AE84-C62FAE1A9874@microsoft.com...
> Hi don, After formatting, visibly there are only two decimals, but when
> you
> click on the cell, it has more than two decimals. How do I truncate the
> more
> than two deicmal points?
>
> "Don Guillett" wrote:
>
>> Just pre-format the cell(s)
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
>> news:7432BE46-74B1-4AC3-BF67-09DF4848B892@microsoft.com...
>> > When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
>> > points. Meaning it will post the value for example xx.xxxxxx. Is there
>> > a
>> > way
>> > that I can paste the value by two decimal points only. Again for
>> > example
>> > xx.xx instead of xx.xxxxxx.
>> >
>> > Thanks in advance for the solution.
>> >
>> > DS
>>
>>
>>

Thanks, Peo works very well.

"Peo Sjoblom" wrote:

> You can use precision as displayed under tools>options>calculation
>
>
> --
>
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
>
>
>
> "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
> news:621A4AFE-9754-430D-AE84-C62FAE1A9874@microsoft.com...
> > Hi don, After formatting, visibly there are only two decimals, but when
> > you
> > click on the cell, it has more than two decimals. How do I truncate the
> > more
> > than two deicmal points?
> >
> > "Don Guillett" wrote:
> >
> >> Just pre-format the cell(s)
> >>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> dguillett1@austin.rr.com
> >> "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
> >> news:7432BE46-74B1-4AC3-BF67-09DF4848B892@microsoft.com...
> >> > When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
> >> > points. Meaning it will post the value for example xx.xxxxxx. Is there
> >> > a
> >> > way
> >> > that I can paste the value by two decimal points only. Again for
> >> > example
> >> > xx.xx instead of xx.xxxxxx.
> >> >
> >> > Thanks in advance for the solution.
> >> >
> >> > DS
> >>
> >>
> >>
>
>
>