Results 1 to 4 of 4

Is there a way to delete decimal numbers only?

Threaded View

  1. 12-14-2008, 06:33 PM #3
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    Or to extend on that
    =IF(MOD(A1,1)=0,A1,"") then copy past back special values
    or even find/replace
    find *.*
    replace with nothing
    Last edited by martindwilson; 12-14-2008 at 06:35 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1