Solved

How to format table numbers in Adobe InDesign CS5

Posted on 2016-09-26
2
82 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
Comment Utility
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
Comment Utility
Thanks Sigurdur.  That's an uncomplicated solution that will probably be best.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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…
Read about why website design really matters in today's demanding market.
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…

772 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

16 Experts available now in Live!

Get 1:1 Help Now