I am completely stumped and have no idea where to start.
Here is my issue:
I have a field that houses prices BUT I HAVE to have the field set as a text field because it has to export to a csv file WITH quotes around it (as text) BUT I also need to make sure that it's formatted to 5 decimal places.
What I would like to be able to do is count the number of characters AFTER the decimal point and add the appropriate amount of zeros (since my numbers will never have more than 5 decimals places) but I don't know how to have it count to the right of a specific character.
Does anyone have any ideas???
Thank you in advance.
Datachick
"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein
Here is my issue:
I have a field that houses prices BUT I HAVE to have the field set as a text field because it has to export to a csv file WITH quotes around it (as text) BUT I also need to make sure that it's formatted to 5 decimal places.
What I would like to be able to do is count the number of characters AFTER the decimal point and add the appropriate amount of zeros (since my numbers will never have more than 5 decimals places) but I don't know how to have it count to the right of a specific character.
Does anyone have any ideas???
Thank you in advance.
Datachick
"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein
