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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3 Answers

Have a used laptop excel asks for product key but i click cancel and have used the software but now it opens and i can't edit or do anything is there a way to fix it or is there a way to download another...


MS Excel is not afree program.
You will need to purchase a copy of MS Office which includes Excel.
For an alternative free program OPEN OFFICE is a full-featured officesuite that's compatible with Microsoft Office.
If you want Open Office you can download this free program.
Click on this link to download :-
http://www.openoffice.org/

Mar 03, 2011 | Excel (SS8SATAS5128400R)

1 Answer

I have a TERASTATION PRO II 2TB 2URM NAS 4X500GB. It seems to be shutting down unexpectedly. I have all the sleep modes disabled and the switch on the back set to auto. No temp issues and I have it...


no i would concentrate on the date time issue than see if you have any more problems i wish you the best of luck and if it works out OK please give me a good vote

Nov 29, 2010 | BuffaloShop Buffalo's TeraStation Pro II...

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Excel question


You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Protect excel


Hi SAJID MEMON,

This one is a little hidden, it's an option under the save as window. So go to file->save as then you should see either a down arrow on the save button, which opens up a sub menu or a tools option in the top right. Under tools select general options, then you should see the password options there.

Jul 06, 2008 | Excel (SS8SATAS5128400R)

2 Answers

How to recover password protected excel files?


You will need recovery software to recover password for the protected files
here is the link
link1
Excel Password Remover 2008
--------------------------------------------------------------------------------------------------
Low feed backs hurt my ratings and I tried my level best to resolve the issue. so please show your appreciation by rating it.
Thanks for using fixya support..You have a wonderful day


Jun 13, 2008 | Excel (SS8SATAS5128400R)

1 Answer

To turn hours and minutes into decimal


Let's say that the time is in cell C3.
Now in cell D3 type =C3*24
then format cell D3 as Number.

Hope this helps.

Apr 24, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Forget excel 2003 password so how break it pl help


You can recover your lost excel password with the use of excel password recovery software likehttp://www.stellarinfo.com/password-recovery/excel-password-recovery.php
First use trail version if you are satisfied with result then go with full version?

Feb 16, 2008 | Excel (SS8SATAS5128400R)

Not finding what you are looking for?
Network Storage Systems Logo

Related Topics:

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Network Storage Systems Experts

Geoff

Level 3 Expert

413 Answers

Brad Brown

Level 3 Expert

13529 Answers

Daily Mehdi
Daily Mehdi

Level 2 Expert

48 Answers

Are you an Excel Network Storage System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...