ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to keep leading zero without changing field to text field? (https://www.excelbanter.com/excel-discussion-misc-queries/52010-how-keep-leading-zero-without-changing-field-text-field.html)

Deni

How to keep leading zero without changing field to text field?
 
I've already tried to customize the number 0#### - the leading zero remains
in Excel but as soon as I save this file and try to use it as a merge
document with word the leading zero is gone again. I then have to go back
and make this a text in order for the zero to remain when merging with word.

tjtjjtjt

How to keep leading zero without changing field to text field?
 
http://office.microsoft.com/en-ca/as...164951033.aspx
--
tj


"Deni" wrote:

I've already tried to customize the number 0#### - the leading zero remains
in Excel but as soon as I save this file and try to use it as a merge
document with word the leading zero is gone again. I then have to go back
and make this a text in order for the zero to remain when merging with word.



All times are GMT +1. The time now is 02:27 PM.

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