Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: convert value in showing in lacs

  1. #1
    New Member
    Join Date
    Nov 2009
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default convert value in showing in lacs

    My balance sheet is prepared in rupees.
    I want to show all figures in Lacs like value 235600 show 23.56

    In previous year i divided all values one by one by inputting /100000 but its so tedious.
    Pl help.

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: convert value in showing in lacs

    In a sparecell enter 100000 then copy it.

    Select the values to convert, Edit > Paste Special, tick Divide and click OK.
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    New Member
    Join Date
    Nov 2009
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: convert value in showing in lacs

    I tried it but my balance sheet show difference bcaz of rounding.

    I also tried .00, for 235600 but its show 235.60 i want to show it 23.56 without separator.

    Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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