Cell is converting my numbers from floating to integers... Help?

[Aristizabal95]

Im having trouble with my project. I've made some simple math through VBA coding, so that the user can input the width and the height of a square, and it outputs the area of the square. Now, that value is shown in a textbox, and it shows both integers and float values. But when I try to output the same value to a cell, it reaches a point where it just takes out the comma, converting the number into a messy integer. ie: desired value: 7,7244 value shown in cell 77244. I thought I could do something by creating a double variable and outputting the value converted to double into the cell, but now the value is getting rounded. Any clues on what happened? Or how to solve it?
Thanks!

[AlphaFrog]

• Right-click on the output cell
• Select Format Cells on the pop-up context menu
• On the Number tab, select the category Number and check the Thousands Separator checkbox

Alternativly, in your vba code you can set the output cell's number formatting.
outputcell.NumberFormat = "#,##0.00"

[Aristizabal95]

Worked perfectly! Thanks a lot!

[Aristizabal95]

Im having a new trouble regarding the same question: I just finished my work and gave it to my boss, he placed it in his computer to find out that my textboxes were taking a float number from a cell and showing the whole number as an integer, which is a really bad problem since what should be $413,45 ends up being $413.457.342.638.132,00. The number changes depending on the user's choices, so I can't just put a constant. What's strange is that it works perfectly in my computer, but it's messy on his! This means that the error is not on the code but on his pc configuration. I have my boss' computer here, looking for anything that may make sense to me, but I'm not sure what could lead to this problem.

Also, I already tried the solution above, but doesn't work this time. Im pretty sure it has to be with my boss' computer configuration since I have no errors in my computer neither my sister's.
Thanks a lot

[AlphaFrog]

Check your boss's Windows Control Panel\ Regional and Language Options
Make sure he has selected a region (e.g.; Spanish-Columbia) where commas are used for decimal point.

[Aristizabal95]

Worked! Thanks a lot!

[AlphaFrog]

You're welcome.