View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
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?