Cutlist Excel output in number format

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

Post Reply
J Sidney Smith
New Member
Posts: 17
Joined: Fri, Sep 18 2009, 1:00PM
Company Name: Lomans Fine Custom Cabinetry
Country: CANADA
Location: Halifax, Nova Scotia
Contact:

Cutlist Excel output in number format

Post by J Sidney Smith »

Is there an option or easy routine to modify Cutlist Excel output which includes field output in a text format, ie (24") to a number format, ie (24)?
Scott Marshburn
Guru Member
Posts: 837
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Cutlist Excel output in number format

Post by Scott Marshburn »

Shure.
1) Under your home tab click on find and select (The binoculars)
2) Click on Find then select the replace tab
3) In find what Type “
4) Leave Replace with blank
5) Click on the replace all button
6) Click ok
7) Now you will see that all of the cells with Numbers that had the “symbol in them have a green triangle in the upper left corner you well also see a yellow diamond with a! In it. Select Cell A2 then while holding down the ctrl and shift key tap the right arrow key then the down arrow key this will select all of the cells in the worksheet with data in them.
8.) Now click on the yellow diamond and select convert to number.
That’s It.
Hope this helps
Scott Marshburn
Post Reply