Hello.
I'm trying to either write or find a function 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
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
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
Bookmarks