View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kingie kingie is offline
external usenet poster
 
Posts: 11
Default How do i save a csv file to keep leading zeros please?

nI wish to save a list of numbers that have leading zeros for use as data in
a notepad file. When i change the file from xls to csv it drops off the
leadibg zeros. I have tried formatting everything as text but when you save
to csv it changes the format back to general. Can you help please?There are
two fields in the data base