I IanT Registered User. Local time Today, 15:00 Joined Nov 30, 2001 Messages 191 Dec 14, 2005 #1 Hi I have data numbers: 1500 60000 8900 How can I put a decimal point two from the right ie: 15.00 600.00 89.00 Thanks.........
Hi I have data numbers: 1500 60000 8900 How can I put a decimal point two from the right ie: 15.00 600.00 89.00 Thanks.........
allan57 Allan Local time Today, 15:00 Joined Nov 29, 2004 Messages 336 Dec 14, 2005 #2 txtTextBoxOrVariable = format(intYourIntegerNumberHere, "0.00")
R raskew AWF VIP Local time Today, 09:00 Joined Jun 2, 2001 Messages 2,731 Dec 15, 2005 #3 Hi - ? format(60000, "0.00") returns 60000.00 while ? format(60000/100, "0.00") returns 600.00 HTH - Bob
Hi - ? format(60000, "0.00") returns 60000.00 while ? format(60000/100, "0.00") returns 600.00 HTH - Bob
