ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   £1.30 merges from excel to word as £1.3 (the end zero is lost) (https://www.excelbanter.com/excel-discussion-misc-queries/35486-%C2%A31-30-merges-excel-word-%C2%A31-3-end-zero-lost.html)

John @ Tiles

£1.30 merges from excel to word as £1.3 (the end zero is lost)
 
I have formatted cells to currency or accountancy but the end zero does not
show up in the formula bar or when I merge to documents. What am I doing
wrong or is it a fault in the application? I have not encountered the problem
before changing to office 2003

Anne Troy

Try this, John:
http://www.officearticles.com/word/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com


"John @ Tiles" <John @ wrote in message
...
I have formatted cells to currency or accountancy but the end zero does

not
show up in the formula bar or when I merge to documents. What am I doing
wrong or is it a fault in the application? I have not encountered the

problem
before changing to office 2003





All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com