+ Reply to Thread
Results 1 to 1 of 1

Problem with moving numberic data read in mail merge add .00001 after all numrict value

  1. #1
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    419

    Problem with moving numberic data read in mail merge add .00001 after all numrict value

    Project Layout

    I m from India & work in a Govt Departmetn PWD where Road maintained section
    So my project show in hindi (hindi fonts enclosed..)

    My proble is

    Cell No. I24 when I enter Y

    2 types Record move
    1 fix record copy (Cell Value A27:W27) to sheet Record
    2n condition record move
    a- if (E6=Head Office Work then copy record cell value (e38:h40) to sheet HO
    b- if (E6 other then Head Office Work then copy record cell value (a29:L34) to sheet Work



    Problem in Moving Fix Record
    When after entry cell no i24 Y I move Fix Record (Cell Value A27:W27) to sheet Record then when I read record from here to mail marge words sheet then Cell Value G,H,I (SHMDR, VR & Total Cost in Record Sheet) this value show difference.. in excel sheet value show 150.79, 7.00 . 157.79 but in word mail marge value show 150.790001, 7. 000001 157.790001

    To fix this problem we use SHMDR, VR & Total Cost (Cell Value AJ, AK, AL) with
    =text()

    pls help me to solve this problem so that we never use =text() in sheet

    so that we can not entery 400 blank row before

    pls help us
    thanks & advance
    my project file enclosed for ur kind persual
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1