Cutlist Excel output in number format
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- 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
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)?
-
- 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
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
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
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467