Decimal places in long formula

[Coors]

I am using J7 as a reference and I formatted the cell to only have 4 decimal places. So it is .8720 I am using J7 in cell O6. Is there any way to get the “1.57904724409449” in cell to be 4 decimal places? I think the formula is keeping the decimal places and not using just the 4 decimal places in J6.

Basically I want O6 to read G0Y1.5790z-14.853S1500

Thanks as always

[Portuga]

try:

Please Login or Register  to view this content.

[NBVC]

try:

Please Login or Register  to view this content.

[Coors]

It didn't like that

It said I entered to few arguments for this function?

[Portuga]

see attached

(your error might have to do with the decimal sign (,) or (.)

or the statement delimiter ; or ,

[Coors]

Thanks guys. I entered in what NBVC posted at it worked. Thanks for the quick post guys and awesome info.