|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
01-07-2012, 10:16 PM
|
#1 |
|
Member (5 bit)
Join Date: Oct 2008
Posts: 16
|
Excel to CSV issues
Hi Guys,
I have an issue when saving from xlsx to csv format. I have column with numbers like 11-12 or 07-08. When I am saving over to CSV, it is taken as 12-Nov or 08-Jul and so on. Any idea how to ensure it will stick as 11-12 or 07-08. thanks VJ |
|
|
|
01-08-2012, 12:53 AM
|
#2 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,385
|
If the excel spreadsheet is displaying the 11-12 or 07-08 format, then you can try this:
Select the column, right click > cell format. Select the "text" category.
__________________
There are two secrets to staying young, being happy, and achieving success. You have to laugh and find humor every day, and you have to have a dream.
|
|
|
|
|
01-08-2012, 01:49 AM
|
#3 |
|
Member (5 bit)
Join Date: Oct 2008
Posts: 16
|
Hi,
THanks for the reply. Somehow it did not work. I have figured it out by adding a single-quote (') before the number. When I save it to CSV it is sticking. thanks |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
