Hello:
Please refer to attached file.
I have data in cell B7:I39.
i need a VB Code to truncate all data to 2 decimal point.
Example : B7 = 32033.8545040666 which i need to be 32033.85
and same with others.
Let me Know if you have any questions.
Thanks.
Riz
Something like:
Select the range you want to truncate, run the code.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hello Olly:
I am using below
Its giving Runtime Error '91'Please Login or Register to view this content.
Ogject variable or With blockvariable not set
Please help
Riz
Okay, if you want to specify the range in the code (rather than working on a selection), then change that to:
Be aware that as written, this will always run on the active sheet. You may want to qualify the range with a worksheet reference - so that would look like:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Olly; 04-08-2014 at 04:33 PM.
Hi Olly:
Superb....Thanks a lot
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks