|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Convert Currency Amount to not include decimal
Has anyone run across something that will tell you how to change this. I know it sounds strange but the interface I'm creating for someone else's program needs the check amount to be 10 digits long in the format of $$$$$$$$cc. I will continue looking but so far have found anything very close to this format.
Thanks in advance for your help! Nadine |
|
#2
|
|||
|
|||
|
When you say change, I take it that you want to remove the "." in the currency amount. If this is the case , you can use the Replace function
x = $4,123.54 x = "$" & Replace(x,".","") x = $412354 Is this what you were asking? lwells |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Convert Currency Amount to not include decimal |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|