Is there any way to keep the extra zero's in a cell that is
run by a concatenate formula. The cell that drives the length is
31.00 but when I use that cell in a concatenate to drive the
cofiguration name (should be 31.00 LG.) it drops it to 31 LG. It
will actaully be fine when I first make it but if I open the table
again it adds another configuration without the zeros. I have the
tried to change the format of the cell with the length to text but
it doesn't help because the cell with the concatenate has to be
general format. Any ideas?
Instead, highlight your range of configuration name cells and set the format to General, then when you do you concatonation use this formula (substritute in the cell address from your design table)
=fixed(B24,2) & "LG"
Having given you the rope, let me explain how you can hang yourself.
If you edit a dimension that drives your configuration name, there are several calamities that can ensue:
1)if you pick a unique value, the configuration name won't change until you edit the design table. If the part is referenced in an open assembly, you won't be given the opportunity to remove the old configuration name/
2)If you pick a value that's used in another configuration, the next time the design table is edited, it will bom out, give you an error dialog and keep whichever configuration comes first in the names list.
3)if you change a dimension and forget to change the scope to 'This configuration, from 'All Configurations'. The next time you edit your design table, you will completely destroy it.
Take it as a serious recommendation: make configuration names arbitrary and fixed. If you want to play with the partnumber or description parameters, knock yourself out
m2c
John