| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!!!!!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!!!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
| I want to transfer a data base file into Excel then do mail merge | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
| How do I format an excel document to transfer to mail merge? | Excel Discussion (Misc queries) | |||
![Kat[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
