Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data export srinivas Excel Discussion (Misc queries) 1 August 25th 06 01:00 PM
how to export data into query tires85 Excel Discussion (Misc queries) 2 August 14th 06 01:49 PM
export excell data as xml moital Excel Worksheet Functions 0 June 22nd 05 08:42 AM
Data Export Ket Excel Worksheet Functions 1 May 3rd 05 04:03 PM
export data to Excel?? a b via OfficeKB.com Excel Discussion (Misc queries) 0 January 15th 05 03:08 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"