I have two sets of numbers that correspond to the minimum and maximum values of an interval. In the database that I am pulling this data from, the numbers are formatted without decimal places, like 680, 1090, or 520000. I want to format them as I input them into an Excel file for a different project.
The first should be formatted as something like:
- 680 => 0.0680
- 1090 => 0.1090
The second set should be formatted like:
- 520000 => 52.0000
- 728750 => 72.8750
Is there a way I can set a column to have formatting that automatically converts the un-formatted number to one with a decimal in the right spot?
edit: reformatted my examples so they were easier to read :)