Convert text field with $ and decimal

N

NC Beach Bum

I need to convert a text field that contains $ and decimal to a text field
with the dollars and two pennies but without the $ and decimal. Such as
$251.87 to 25187.
I tried the FIXED but that only takes out the $ sign.
What is the best way to do this?
 
M

Marshall Barton

NC said:
I need to convert a text field that contains $ and decimal to a text field
with the dollars and two pennies but without the $ and decimal. Such as
$251.87 to 25187.
I tried the FIXED but that only takes out the $ sign.
Click to expand...


How about
Fix(amt * 100)
or maybe you need a string result:
CStr(Fix(amt * 100))
 
O

Ofer

Try using the function replace to remove the $ and the .

replace(replace(FieldName,"$",""),".","")
 
Top