ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   values in userform (https://www.excelbanter.com/excel-programming/349068-values-userform.html)

Antonov

values in userform
 
hello again everybody. I need some values from my userform to my sheet to be
always in Euros. Even though I've formatted the receiving cells to
"currency" this doesn't happen. Can somebody please help?
thanks



TheIrishThug[_15_]

values in userform
 

did you format it to be currency *with* the ero symbol? if you just set
the cell as currency it will default to $.


--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile: http://www.excelforum.com/member.php...o&userid=29682
View this thread: http://www.excelforum.com/showthread...hreadid=496520


Antonov

values in userform
 
yes, it is with the euro symbol
"TheIrishThug"
wrote in message
news:TheIrishThug.20rtzm_1135808702.6512@excelforu m-nospam.com...

did you format it to be currency *with* the ero symbol? if you just set
the cell as currency it will default to $.


--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile:
http://www.excelforum.com/member.php...o&userid=29682
View this thread: http://www.excelforum.com/showthread...hreadid=496520





All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com