cereal_killer Posted March 17, 2011 Share Posted March 17, 2011 Hi! The field contains this amont in this format: 33.078.50 and I need to convert it to 33078.50 or 33,078.50 I tried Substitute ( amount; "."; "") but this gives me 3307850 Can someone give me a hand? Link to comment Share on other sites More sharing options...
Lee Smith Posted March 17, 2011 Share Posted March 17, 2011 33.078.50 is not a number, it is text. Link to comment Share on other sites More sharing options...
cereal_killer Posted March 17, 2011 Author Share Posted March 17, 2011 Well, it is actually a number field, but it looks that the data stored in it is text. What would be the best way to convert it? Link to comment Share on other sites More sharing options...
comment Posted March 17, 2011 Share Posted March 17, 2011 Assuming ALL amounts follow the same pattern, and that the periods are in the data itself (i.e. not produced by field formatting), change the field's type to Text, then try = Substitute ( Amount ; "." ; "" ) / 100 Link to comment Share on other sites More sharing options...
cereal_killer Posted March 18, 2011 Author Share Posted March 18, 2011 Thank you very much, Sir. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4786 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now