i have a workbook used in solidworks 3d design software. i don't know
the very deep functionality of it all, but basically it goes out in a
model with holes in it and gets the hole related info and puts it on a
spread sheet called a hole chart. this is used by the toolmakers to
make the part instead of having to look at hundreds of dimensions. here
is the problem: it puts the harvested hole info on a data sheet, the
hole chart is on another sheeet with some very long
functions/equations. it clames to change the precision of the decimal
to edit the place setting on the data sheet and hit f9 to update. if
you go back to the hole chart sheet it will update accordingly but will
drop the trailing digit if it is a zero. i need them to show. any
takers? TIA

i may not be able to contribute much in the Excel world but if there
are and solidworks users with questions fire away ;0)

Although I cannot fully understand, it might just be an issue of cell
formatting. You can format the cells to display a fixed number of
decimal digits. Choose the Number format from Format|Cells... Number
tab, and set the number of decimal digits.

HTH
Kostis Vezerides