Re: how to paste values created by custom format?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Oli,

now the mail merge has decided
that all the values in the column are zero. Hmm not good, any suggestions?

Can you change the data type in the mail merge to text? (sorry, no Word
expert here<g>)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

.

Relevant Pages

  • Re: Using custom Label word merge - data dropped
    ... It is the change in data type that is causing your problem. ... > Have an 8 pg custom Label word merge doc w/excel file as data source. ... > places a zero in a field that should have 354k4. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Divide by Zero when it should not.
    ... values to Double data type. ... to change the data types within the query. ... I have a query that return a "Division by Zero" error ... I get the division by zero error then the query stay in design mode, ...
    (microsoft.public.access.queries)
  • Re: Leading zeros in number fields
    ... you need to switch the data type to text. ... changing it to General Number and niether allows a leading zero. ... other format options seem to make sense for this. ...
    (microsoft.public.access.gettingstarted)
  • Re: REPORT; If Null return "0"
    ... FROM ALLTasksFilter LEFT JOIN ON ... instance, Nzwould report any null values as zero. ... putting this inside your sum function, you are converting the nulls to ... so long as your specified value matches the data type of ...
    (comp.databases.ms-access)
  • Re: On to Bulk Insert issues
    ... carefully specifying the data type of the input file columns. ... All the nulls in that column are ... For this column, zero carries a very ... different meaning from null. ...
    (comp.databases.ms-sqlserver)