# Thread: FIELD ZERO SUPPRESSION PROBLEM

1. ## FIELD ZERO SUPPRESSION PROBLEM

in my case ,i have three things (excel sheet,data link,text)

in the excel sheet ,i wrote the number of the first part in ground floor,and i managed by equation to have always three digits.so when i write 30,it will return 030.

in dwg file,i made a single cell table and linked it to the mentioned excel cell (030) and it worked well

in the paper space match line text,i put a field to link it to the single cell table and add a certain number 3 for example (030+3).

i made that in order to when i modify the number in the excel sheet,the data link will be updated, and the match line will reflect the new value.

at last ,the problem is that the match line text field suppresses the zero (030+3=33)
any suggestions to show that zero

2. ## Re: FIELD ZERO SUPPRESSION PROBLEM

You could add a field format with prefix of 0 to the formula field. Unfortunately it'll only work for 010 through 096. A value of 102+3 would then show as 0105. Unfortunately ACad doesn't have a minimum digits format like you have in Excel.

You may add another column in excel which is formatted to include the 0, and have a formula to add the 3. Then the layout field can be copied from this. It's a workaround, but should at least give you the correct result.

3. ## Re: FIELD ZERO SUPPRESSION PROBLEM

Originally Posted by irneb
You may add another column in excel which is formatted to include the 0, and have a formula to add the 3. Then the layout field can be copied from this. It's a workaround, but should at least give you the correct result.

thank you very much for your input.
as for your idea,i will be forced -as i understood- to make a data link for each match line text to the corresponding cell in the excel,which will lead to too many data link which means:
-slow down the pc.
-very tedious work.
thanks again

4. ## Re: FIELD ZERO SUPPRESSION PROBLEM

Not really a pleasure, since it's not fixed yet (in my mind at least). But you're welcome anyway. You're correct in saying this workaround's going to cause a lot more linking, thus slowdown .

I have tried doing it using the Diesel expressions field, which does have the ability to program an extra 0 prefix (or whatever you want) through an if function. Unfortunately ADesk (in their infinite wisdom) made the Diesel field not work like the formula field where you can insert a nested field pointer. So you can't pick-up the value from a text entity.

And of course as you've found out, the formula field leaves a lot to be desired.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•