thanks in advance to anyone who can help me out of this jam....
- I have a column(s) that has 3, 4, and 5 digit numbers that are supposed to represent Dollar figures but the decimal places are not present:
12595 ---> 125.95
695 ----> 6.95
1095 ---> 10.95
- Is there a way to insert a decimal 2 places to the left of each number in the entire column? I only have 18,000+ records.....
- currency formatting is not necessary to include the $ sign
If you can help me out I promise to consult the Beer gods to bless you for eternity
kindest regards,
budzooka
- I have a column(s) that has 3, 4, and 5 digit numbers that are supposed to represent Dollar figures but the decimal places are not present:
12595 ---> 125.95
695 ----> 6.95
1095 ---> 10.95
- Is there a way to insert a decimal 2 places to the left of each number in the entire column? I only have 18,000+ records.....
- currency formatting is not necessary to include the $ sign
If you can help me out I promise to consult the Beer gods to bless you for eternity
kindest regards,
budzooka