Jason Barr

Keeping extra zero's in table?

Discussion created by Jason Barr on Oct 11, 2007
Latest reply on Oct 12, 2007 by Shawn Applegate
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?