Question about Excel (SS8SATAS5128400R)

1 Answer

Unable to Change Dates

Hi ,
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.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Hi,
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.
Thanking u.

If u found any Douts, Suggestions ,Plzz let me know.

Posted on Jun 27, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help?


I assume that the dates you want adjust are in date form and are in regular columns (or rows).
If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))
where the original date is in cell A3.
You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

Oct 17, 2013 | 1996 Italdesign Formula

2 Answers

How to convert the csv file into excel form?


When you choose to open the csv file - A pop up box will take you through the steps - You need to highlight the seperators as Excel is currently unable to do this.

Once you are going through the process you will be able to select, hash, space, comma as the seperataor into the respective columns.

Apr 27, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Zenith Redi_set clock radio Z230S


Describe your problem: Depress MONTH/DATE and ALARM1 for 3 seconds and display will show DST 'start' month,week,and date.
Display will show 4F 4.1, alternately flashing

4F = April First week. 4.1 = April 1.That is the old dates for change. What we want to do is to change to the new dates. Once it is done, it will change in the new dates as it did on the
old dates..

Hold down the MONTH/DATE button for 5 seconds, and while pressing the - or down button3 times, until the display shows '3'F2.
3 is month F2 is the week.
=March 2nd week.
You have successfully change the March changeover.

Now for the November change.
Depress and hold MONTH/DATE and ALARM2 after 3 second the display will show DST 'end' month,week, and date.
First digit will be 10 =month. second digit will be L=Last week, and date, will flash alternately.
While holding down the MONTH/DATE press the + or UP button once the display will show 11 (November) and F (first week) and 1 as date alternately flashing.
You have successfully set it for the next 100 years

Apr 17, 2009 | Zenith Z230S Clock Radio

1 Answer

Changing dates format in a spreadsheet


i want professional office 2007 product key

Mar 29, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How to calculate the difference of two dates by year, month and day using the formula in excel?


To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

DATE DIFERANCE BETWEEN SELECTED COLOUMN


Are you trying to figure the difference in days between these dates and one single date (Dec. 31, 2008 for example)?

Whatever you're trying to do, here is the formula, assuming you're starting in A1:
Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008)
Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008)
In C1 put B1-A1 and that will give you the number of days between those two dates.

Dec 27, 2008 | Microsoft Excel for PC

1 Answer

Importing csc files


Hi freaks11,
I am DennisGladx and I hope to assist you.

This sounds like the Column of the data you want should be changed when you import the text file.
Right click on the column letter,
Left click on format cells from the drop down list and select the cell Con-tense you want to display.

Glad to be of assistance
please rate the solution - I can learn from your rating - Thanks

Oct 24, 2008 | Microsoft Excel for PC

1 Answer

Formula for Date


Make that column fixed and give the variable date and value 26/Month of year/year

That is the logic Can you do that

Fixya?

Mar 21, 2008 | Microsoft Excel for PC

1 Answer

Want to update the dates in excel spreadsheet


Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.

Good Luck,

Jan 16, 2008 | Computers & Internet

2 Answers

Conversion from date to text formet


Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.

Nov 18, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

92 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

3076 Answers

Bill Boyd

Level 3 Expert

34932 Answers

Lala

Level 2 Expert

34 Answers

Are you an Excel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...