Help please. I'd like to write formulas using Excel output.

[Steve Dyches]

I have no problem exporting the cutlist and sorting.

What I can't do is write formulas from the data. The dimensions appear like '42 7/16\" instead of just a number. Anyone know how to convert the dimensions to just a number, not text, no ' or \".

Thanks in advance,

Steve

[Glenn Van Reason]

After exporting to excell hit Edit - Replace. in the Find What put '
in replace with leave it blank. hit replace all, this will strip all the ' from the numbers. Do this again with \" in place of ' and you now have numbers.

[Steve Dyches]

Thanks VERY MUCH!!!!!!!!!!
It's the little things in life that make me happy.

[DanEpps]

Make sure the cells containing the numbers are formatted as numbers.

Select the column header, right-click and choose \"Format Cells.\" In the left-side list, choose \"Fraction\" and in the right-side list, choose \"Up to three digits.\"

[Ed Conklin]

Another way to convert the number inported in a string format is through a formula within Excel. The simple formula that will do this is
'=value(A1)'. A1 is assumed to be the cell with the number in string format. The value of that cell is stored as a number in the cell with the formula.

I find that, that using this method, I can make the whole process a little more automated.

As stated is a prior reply, you need to make sure that the cell format is set the way you want it or you risk Excel converting fractions to decimal, etc.

[Glenn Van Reason]

I treid this in excel and it doesn't work, in cell F26 I put 256mm and in the next I put =Value(F26) and I get #VALUE!

It's the \"mm\" that cause the problems and as soon as that is stripped excel asumes number for the cell.

[Ed Conklin]

Sorry about that. When I wrote the formula, I didn't think about metric. Try the following formula. It will strip off the 'mm' and then convert the string to a number.

This formula assumes the imported number (stored as a string) is in E16.

=VALUE(LEFT(E16,LEN(E16)-2))