How to format table numbers in Adobe InDesign CS5

ttist25
ttist25 used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
Thanks Sigurdur.  That's an uncomplicated solution that will probably be best.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial