By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Replace decimal in output

P: 1
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 Images
File Type: jpg currency.JPG (3.8 KB, 98 views)
Mar 16 '10 #1
Share this Question
Share on Google+
1 Reply


yarbrough40
100+
P: 320
This function exists in vb.net. Pretty sure VBA uses it too.

Enjoy!
Expand|Select|Wrap|Line Numbers
  1. Replace("4,567.750",".","/")
Mar 17 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.