Solved

How to format table numbers in Adobe InDesign CS5

Posted on 2016-09-26
2
122 Views
Last Modified: 2016-09-28
Hello,

I'm trying to format numbers in an InDesign table that I imported from Excel (File-->Place...--->Table: Formatted Table".  The Excel file has several columns with a custom format ".000".  This displays as expected in Excel (i.e., 0.000 displays as .000) but when I place the Excel worksheet in a table in InDesign it appears as "0.000".  

InDesign preserves the Excel format for cells that have a non-zero value (i.e., .092 appears in InDesign as .092) but wherever the value is .000 in Excel, InDesign adds a leading zero (0.000).  

I've got a ton of tables to create for this document and would prefer not to have to hit each cell and delete the leading 0.  

Any tips on how I can achieve this?

Thanks!
0
Comment
Question by:ttist25
2 Comments
 
LVL 22

Accepted Solution

by:
Sigurdur Armannsson earned 500 total points
ID: 41817396
I am not sure this helps you, but if the solution is to get rid of the zero in front of the period, you could use the GREP tab in the Find & Replace and

Find what (inTable): 0(\.000)
Change to: $1

This preserves what is in the first bracket in Find.
0
 
LVL 1

Author Closing Comment

by:ttist25
ID: 41819789
Thanks Sigurdur.  That's an uncomplicated solution that will probably be best.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Photoshop 7 and CS2 Indesign saving to a 4TB drive 7 53
cant save as jpeg 2 80
How to take a square picture 4 121
Illustrator Artboard Maximum Size 3 137
HOW TO CREATE A WEB 2.0 IMAGE WITH A REFLECTION I would like to start by saying I know Web 2.0 isn't a style. It is actually the practice of information sharing or  collaboration on the Web. It is also associated with the technology that is used …
In this article, I'll explain how to change the color of a selection in Photoshop. I'm sure there are a couple different ways to do this in photoshop, but this is my preferred method in Photoshop. I am using Photoshop CS6 and I will be adjusting the…
In this tutorial viewers will learn how to restore old photos in Photoshop (an introduction to the Clone tool) Zoom into a damaged area: Click on the "Stamp" icon to use the Clone tool. Hold the Alt key and click to select a region. Click again, and…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now