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
Help please. I'd like to write formulas using Excel output.
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- Junior Member
- Posts: 82
- Joined: Wed, May 24 2006, 1:52PM
- Location: Beech Island, SC
- Contact:
-
- 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
-
- Junior Member
- Posts: 82
- Joined: Wed, May 24 2006, 1:52PM
- Location: Beech Island, SC
- Contact:
-
- New Member
- Posts: 7
- Joined: Sat, Apr 08 2006, 8:36AM
- Location: Rhode Island
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.
'=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.
-
- 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
-
- New Member
- Posts: 7
- Joined: Sat, Apr 08 2006, 8:36AM
- Location: Rhode Island