I need a query to reformat/convert salary data that has been entered as text as 4050092 (which represents $40,500.92) into 40500.92, but keeping it as a text format. Basically, I need something that would take a cell's data, count over two places from the end (right), and insert a decimal point. Any suggestions?
--spyder
--spyder