Question about Excel (SS8SATAS5128400R)
i opened CSV file with Excel and devided text to coloumns.
all dates are wrong. some dates showing date and month in riverse,
if date is less than 13 (up to 12) it is going into month place. if greater than it showing in dd/mm/yyyy. even i gone through formats / Date/ selected particular format. some dates still showing previous. some cells only accepting the change.
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :
first change the settings in ControlPanel/Regional and Language Options.
Click on Customize button/open the Date Tab and set the date format there.
and then proceed with CSV.
Open CSV in Excel and divide Text to coloumns.
Ur all Date Cells will be in particual Format.
and Select that coloumns and right click Format Celss....etc.
If u found any Douts, Suggestions ,Plzz let me know.
Posted on Jun 27, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 17, 2013 | 1996 Italdesign Formula
Apr 27, 2009 | Microsoft Office Excel 2003 for PC
Apr 17, 2009 | Zenith Z230S Clock Radio
Mar 15, 2009 | Microsoft Office Excel 2003 for PC
Dec 27, 2008 | Microsoft Excel for PC
Oct 24, 2008 | Microsoft Excel for PC
Jan 16, 2008 | Computers & Internet
Nov 18, 2007 | Computers & Internet
Apr 30, 2017 | ZTE Computers & Internet
92 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: