Results 1 to 10 of 41

Thread: copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-18-2020, 09:30 AM #5
    fixer
    fixer is offline
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    remove third number after decimal and then remove the decimal

    I will place the macro in a seperate file macro.xlsm
    and i have a file name 1.xls
    in 1.xls in column K i have data (i have attached the sample pic of that)
    what i need is i need a macro that will remove third number after decimal and along with it it should remove the decimal
    Result will be
    1090.699 after runing the macro the ouput will be 109069
    147.965 after runing the macro the ouput will be 14796
    264.4785 after runing the macro the ouput will be 26447
    30.2495 after runing the macro the ouput will be 3024

    plz help me in solving this problem by vba
    Attached Images Attached Images
    • File Type: jpg 1.jpg (3.8 KB, 7 views)
    Last edited by DocAElstein; 04-19-2020 at 08:40 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Dir File Copy and Paste: Check if file exists then copy file from one directory to another. Bat File
    By fixer in forum Test Area
    Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. VBA Simple Copy and Paste between two workbooks based on criteria
    By fixer in forum Excel Help
    Replies: 6
    Last Post: 08-28-2019, 09:42 AM
  3. copy data and paste it in another sheet
    By newbie2 in forum Excel Help
    Replies: 1
    Last Post: 07-15-2015, 01:38 PM
  4. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 PM

Tags for this Thread

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