Linking to excel, formulas in cells result in "-1"

Forum|Forum|3 years ago
April 7, 2022
2 replies
196 views

Hi!

I have an excel document linked to InDesign which contains text and numbers (some of which are formulas). I have noticed that the formulas in excel which result in text (e.g a formula is used to populate a specific date in a cell - 31 December 2021) pull through to InDesign as a "-1". Also, where there is a cell in excel that has a decimal, e.g 1.1 it pulls through as 1 and not 1.1.

Thanks!

How to

This topic has been closed for replies.

L

Laubender

Community Expert

If copy/paste is the right workflow to get rid of the formulas but preserving the visible results, yes then do that.

Regards,
Uwe Laubender

( ACP )

L

Laubender

Community Expert

You first have to get rid of all the formulas in the Excel file and "normalize" them to the result texts only.

Also check your import options when you place Excel files. There is a control of the number of decimal places.

Regards,
Uwe Laubender

( ACP )

E

Ed2393779390koAuthor

Participant

Thank you very much! So just to clarify, when you say normalise you effectively mean copy, pasting values only in the excel to get rid of the formula? No way to keep the formulas in the excel file?

Thanks again!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded