Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2007-11-08 : 04:57:57
|
| Hi, i have a text box that contains a format. I;m getting values like 33.33333. i want to have 33. what format do i have to use in order not to have decimal number. i want this fomat 33%. Any help? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-08 : 04:59:17
|
You might have comma as decimal separator and thus the format do not work.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2007-11-09 : 02:33:31
|
| I found a solution which is to use CInt function and if i want i can use Ceiling function combinated with cInt function too. |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-11-23 : 10:32:18
|
| Try setting Format Property to #0% (you will need to divide your value by 100 to give 0.333333 as this will display as 33%) |
|
|
|
|
|
|
Percentage format