Quote:
Originally Posted by Mazzaropi
--------------------------------------------------------------------------
Dear AnnieMa, Good Evening.
Itīs a little confused to understand your variants.
But I tried to help you developing a kind of compass based on your explanation.
Itīs he 07-02-2011_ExcelBanter_Pontos_Cardeais.xls
I used Excel 2003 to do this.
Do a test and tell me if it worked for you.
Feel free to ask anything about it.
|
Hello again,
I have encountered another problem. The X and Y columns are formatted as numbers, with two decimals. However when the last decimal is zero it is rounded the nearest integer and consequently only one decimal, i.e. 113.10 - 113.1. This results in XY coordinates as 113.1x 114.9 y and a subsequent #VALUE!-error when the your calculation is applied.
How can I format the columns so that two decimals ALWAYS are shown? Alternatively, how can I alter the calculation to work also with one decimal-numbers?
Again, thanks a lot!