ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you export data and keep the same fomating? (https://www.excelbanter.com/excel-worksheet-functions/140220-how-do-you-export-data-keep-same-fomating.html)

Kath

How do you export data and keep the same fomating?
 
I've formated some cells so the read 0001, 0002 ect. This is how i'd like
the data to show when i export in a mail merge but at precent i can only get
it to merge 1,2 ect. Dose anyone know how to set it up so it reads all
digets as data?

Peo Sjoblom

How do you export data and keep the same fomating?
 
Format as text and type in the leading zeros


--
Regards,

Peo Sjoblom


"kath" wrote in message
...
I've formated some cells so the read 0001, 0002 ect. This is how i'd like
the data to show when i export in a mail merge but at precent i can only
get
it to merge 1,2 ect. Dose anyone know how to set it up so it reads all
digets as data?





All times are GMT +1. The time now is 08:20 AM.

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