Thx for your reply! Sadly, it doesn't work.
I have three textboxes; txt1, txt2 and txt3. Example: In txt1 the number "200" is entered. In txt2 the number "150,50" is entered. Now, the result i'm hunting for which txt3 should be showing, is "350,50". But as it is now, it shows "350" or "351". Another example: In txt1 the number "1500,95" is entered. In txt2 the number "150,75" is entered. Now, the result in txt3 should be "1.651,70" - but sadly it is not. Txt3 shows "1650". I hope you can follow my thinking. On 24 Aug., 12:32, AmbiguousError <gary.ker...@gmail.com> wrote: > Hi there, > Not sure how you're calculating your currencies? > But if you enter =ROUND(A1,2), where A1 is the result of your currency > calc & 2 is the number of decimal places you're rounding to. > Format this cell as the currency you'd like, > Sorted? > > On Aug 24, 3:21 pm, Ciffor <clausflygenr...@email.dk> wrote: > > > Hey out there, > > > First of all, a big thank you to all the MS Excel experts out there, > > sharing there knowledge at no cost at all in this forum. > > > Secondly, my question. > > > The subject title, actually says it all. > > > My goal is to calculate the currency contents within two textboxes. > > The result should be with two decimals. > > > I've tried everything i know, from val to format, and with CCur and > > CDec. I can't seem to get it to work. > > > Kind regards > > Ciffor --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
