About Us

Mazzaropi

Dear AnnieMa, Good Morning.

Coul´d you save your file at a free site, www.4shared.com and put the link here, to easier the answer?

I believe that will be faster to help you.

I want to help you.

Quote:

Originally Posted by AnnieMa

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!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I set the unit value on the x-axis?	Terry	Charts and Charting in Excel	1	February 14th 09 07:49 PM
Absolute cell reference will not remain absolute.	Mike K	Excel Worksheet Functions	1	October 8th 08 07:12 PM
Unit Forcast	Larry[_4_]	Excel Worksheet Functions	1	July 25th 07 01:05 PM
CF for over/under mean unit	marcy	Excel Worksheet Functions	1	April 21st 05 05:42 PM
Need help with unit formulas	Tom Andrews	Excel Worksheet Functions	1	December 9th 04 10:29 PM

Menu

About Us