Hello.

I don't know much about how macros work, but it was suggested that I move this question from the functions thread into this one.

I'm trying to either write or find a function (or macro) that will automatically insert a decimal into different types of numbers. My spreadsheets contain three digit numbers and four digit numbers, but I want to auto place a decimal one space to the right of the first number on both of these.

For example:

256 | 1285
255 | 1290
254 | 1295
259 | 1280
240 | 1300

I would like to be able to type those numbers but have it come out as:

2.56 | 1.285
2.55 | 1.290
2.54 | 1.295
2.59 | 1.280
2.40 | 1.300

Short of having a fixed decimal at 3 and always having to add a zero to any three digit number and having one less decimal point in those boxes, I'm stumped as to how to accomplish this. I would like to only have to type the three numbers and the four numbers without manual placing decimals or adding zeros.
Any help would be great.

Thanks