View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lyndamac lyndamac is offline
external usenet poster
 
Posts: 1
Default 0 missing from currency when merging documents

Hi there,

I am merging a document from excel to word. When I merge them my
currency loses a 0 at the end.

i.e £7.50 ends up as £7.5 and I am manually adding in a 0 at the end
of each one. This is rather tedious as you can imagine, as there are
over 200 entries.

Is there anyway I can do this quickly, maybe my settings are wrong. I
have currency setup in excel - currency 2 decimal places.


Please help


Thanks

Lynda