ExcelBanter - In a data merge, how do I get 12.5 to transfer as 12.50?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - In a data merge, how do I get 12.5 to transfer as 12.50? (https://www.excelbanter.com/excel-discussion-misc-queries/181794-data-merge-how-do-i-get-12-5-transfer-12-50-a.html)

Kat[_2_]

In a data merge, how do I get 12.5 to transfer as 12.50?

I am doing a data merge from excel to publisher and I need the data to
transfer over as 12.50 but it will only transfer over as 12.5. I have changed
this in format cells but nothing seems to work. Any help would be
great!!!!!!!!!!

David Biddulph[_2_]

In a data merge, how do I get 12.5 to transfer as 12.50?

=text(a2,"0.00")
--
David Biddulph

"Kat" <Kat @discussions.microsoft.com wrote in message
...
I am doing a data merge from excel to publisher and I need the data to
transfer over as 12.50 but it will only transfer over as 12.5. I have
changed
this in format cells but nothing seems to work. Any help would be
great!!!!!!!!!!

All times are GMT +1. The time now is 12:43 AM.