Replace decimal in output

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • johnroy16
    New Member
    • Mar 2010
    • 1

    Replace decimal in output

    Need Amount column to display the figure with amount for eg.
    4,567.750 to show as 4,567/750 instead of decimal needed
    slash to separate the smaller unit.

    I have attached the present form which is to be converted
    for ready reference.

    Code at present written as

    ="**" & Format([Amount],"#,##0.000" ) & "**"
    Attached Files
  • yarbrough40
    Contributor
    • Jun 2009
    • 320

    #2
    This function exists in vb.net. Pretty sure VBA uses it too.

    Enjoy!
    Code:
    Replace("4,567.750",".","/")

    Comment

    Working...