Publisher Data Merge number precision

[EMcK]

Hi,

Hopefully I'm posting this question in the right place.

I'm using data merge to pull through time results from excel, all fine with that.  In excel I have the cell formatted to m:ss.sss (ie 1:34.572) as its to do with accurate time splits.  However when this comes through Publisher is rounding this, so rather than being 1:34.572 it comes through as 1:35.  Is there a way to change the precision of the text coming through so its formatted to the same?

I assume the text box can be formatted to match this however I can't find the option for this, can anyone advise?

Thanks,
Ewan

[David in Яuislip]

My ancient excel doesn't understand m:ss.sss and it gets shortened to m:ss.ss so the seconds are repeated
m:ss.000 works but Publisher V1 doesn't understand it so the only way I could get ms to work in a data merge is to use a csv file rather than xlsx

[EMcK]

Hi David,

Thanks for your response, never considered that csv is a better way to do data merge, that's resolved this.

You are also correct with your note on formatting in excel, it is mm.ss.000, not mm.ss.sss as I suggested as that just repeats the seconds number.

Ewan

[lacerto]

Obsolete.

[EMcK]

Hi Lacaerto,

Thanks for this option too, and the explanation how it works.  I tried to covert to text before posting but got my formula wrong for it.  It works too and gives me an option to keep using excel.

Ewan