Thanks but as above
Format in excel - is correct - no decimal places
but all numbers merged leave varying trailing .00 ie some are 0 others are .00000
It sounds like what is needed is for the numeric fields to be treated simply as text. This is also a formatting setting in Excel. The end result should be that in the delimited file the numbers are enclosed in quotes.
Hope it helps
text works - any numeric formatting does not... Go figure
Use merge alot not had this issue before.
Many thanks for the help
Glad you got it working.