• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

How to format table numbers in Adobe InDesign CS5

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
ttist25
Asked:
ttist25
1 Solution
 
Sigurdur ArmannssonDesignerCommented:
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
 
ttist25Author Commented:
Thanks Sigurdur.  That's an uncomplicated solution that will probably be best.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now