Navigating Posted February 10, 2005 Share Posted February 10, 2005 Hi All, Quick question...how do I format or calculate a number field to add a $ symbol plus a decimal to the number? Example: number entered into the field 12345, when I tab out of the field I would like the number to show $123.45 Thanks in advance, Sheryl Update: I found RussBaker's Handy Bits file and was able to get the $ and decimal to display, but the number that displayed was $12,345.00. Does anyone know how to get the number to display without the zeros? Just display the actual number $123.45 thanks again, sheryl Link to comment Share on other sites More sharing options...
This topic is 6624 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 account
Already have an account? Sign in here.Sign In Now