Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

.csv file


  • Please log in to reply
2 replies to this topic

#1 valley_girl1919

valley_girl1919

  • Members
  • 24 posts
  • OFFLINE
  •  
  • Local time:02:21 AM

Posted 01 March 2011 - 06:30 PM

Hi! I am having problems with saving a excel document as a .csv file. I open an excel file and right click on a cell and select format cells and then I select custom and type in mm/dd/yyyy for the date format I need and select okay, so when I type in a date like 05/05/2005 it will stay that way in excel. After this I click save and save file type to .csv, but before saving a message pops up saying "may contain features that are not compatible with CSV" and it will not let me save in .csv format. The thing is that a certain company needs the .csv format and when I send it they need the dates i enter to be in 00/00/0000 cell format. Does anyone know of a way to save a .csv file with the date being formatted that way?

BC AdBot (Login to Remove)

 


#2 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,579 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:04:21 PM

Posted 01 March 2011 - 06:47 PM

When you enter the date into a cell in EXCEL put a ' symbol in front of it. So you would type '05/05/2005 into the cell and press enter. Then you should be able to save it as a CSV file.
The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw

#3 Theonus

Theonus

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:England (North East)
  • Local time:06:21 AM

Posted 11 March 2011 - 03:35 PM

"may contain features that are not compatible with CSV"


Usually this is just a warning also to make you aware that .csv isn't going to retain your formatting (like colours and such). Hope the above post helps anyhow, I believe it will solve your problem.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users