The Shadow Posted September 18, 2004 Share Posted September 18, 2004 FM7 by default shows numbers in scientific notation, here's a custom function that takes a number to text, but keeping the zeros around. It has an option to add commas every three digits also: So, the call: Link to comment Share on other sites More sharing options...
andries Posted October 14, 2010 Share Posted October 14, 2010 you just saved my day... I don't understand why FileMaker doesn't have an option so you can actually choose how to store the data. Link to comment Share on other sites More sharing options...
comment Posted October 14, 2010 Share Posted October 14, 2010 I am not sure I understand the problem here. If you enter -4.5e+23 into a Number field, it will be interpreted correctly. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4956 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