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

Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal

Post Reply
Steve Dyches
Junior Member
Posts: 82
Joined: Wed, May 24 2006, 1:52PM
Location: Beech Island, SC
Contact:

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

Post by 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
Guru Member
Posts: 459
Joined: Tue, May 17 2005, 4:00PM
Company Name: TBA
Country: AUSTRALIA
Location: ORANGE NSW AUSTRALIA every now and then between trips lol

Post by 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.
This message made from recycled electrons.
Steve Dyches
Junior Member
Posts: 82
Joined: Wed, May 24 2006, 1:52PM
Location: Beech Island, SC
Contact:

Post by Steve Dyches »

Thanks VERY MUCH!!!!!!!!!!
It's the little things in life that make me happy. :lol:
DanEpps
Wizard Member
Posts: 5852
Joined: Thu, Jul 28 2005, 10:18AM
Company Name: Dan Epps
Country: UNITED STATES
Location: Rocky Face GA

Post by 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
New Member
Posts: 7
Joined: Sat, Apr 08 2006, 8:36AM
Location: Rhode Island

Post by 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
Guru Member
Posts: 459
Joined: Tue, May 17 2005, 4:00PM
Company Name: TBA
Country: AUSTRALIA
Location: ORANGE NSW AUSTRALIA every now and then between trips lol

Post by 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.
This message made from recycled electrons.
Ed Conklin
New Member
Posts: 7
Joined: Sat, Apr 08 2006, 8:36AM
Location: Rhode Island

Post by 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))
Post Reply