Results 1 to 5 of 5

Cut / Paste excel data without decimal values

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2009
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    49

    Cut / Paste excel data without decimal values

    Hi all,

    Probably a simple question but doing my head in trying to fix...

    The data comes from the divison of two stock prices that are updating in realtime..... hence i will get a figure of lets say 2.5563. I have it set so that the cell auto rounds to the nearest number even though the formula bar displays the above figure...

    My problem arises when I cut and paste this data into a new cell, the decimal figures are still there. I have to have this figure pasted as 3...... not 2.5563 and rounded up to 3...

    Anyone know how to fix..?

    Thanks!
    Last edited by oldchippy; 07-13-2009 at 03:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1