[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How to format table numbers in Adobe InDesign CS5

Posted on 2016-09-26
2
Medium Priority
?
252 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Accepted Solution

by:
Sigurdur Armannsson earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 …
Introduction When sharing photos, especially via e-mail, the large resolution images that most cameras take today make for extremely large file sizes. The time required to upload these files to forums, send in e-mails, post to blogs or even placi…
In this tutorial viewers will learn how to correct colors in Photoshop using the Color Balance adjustment Open a photo for editing in Photoshop: Open a photo for editing in Photoshop: Select "OK" on the dialogue: The Color Balance adjustment works b…
In this tutorial viewers will learn how to select a color range in Photoshop and how to easily apply them to multiple projects. Open an image for editing in Photoshop: Open the select Color Range Selection tool by going to Select > Color Range: Sele…
Suggested Courses

649 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