spreadsheet

A question: I have a cell in excel with date format DD-MM-YYYY. This cell has a date for example 19-4-2023. I have another cell with the format YYYY-MM-DD How can I automatically convert the date 19-4-2023 to 2023-4-19? Thanks José Paiva

I have lost the "send to zip" function for an Excel spreadsheet. I used the Copyright Office's spreadsheet format but when I right click on it for the "send to zip" function, the file becomes grayed out and "Not responding". No problem with other files -- just this one. I did change the...

I entered a password record consisting of three columns and spaced them to accommodate the text. When I tried to print the pages only columns A and B printed. I would appreciate advice on how to print the complete record thank you.

Hi, Please note this is Excel 2007 We have a user who is working on an Excel Spreadsheet and when he saves this it changes the links (The ones that are linked to other spreadsheets) to the same network location but through a different path. This is causing an issue as the file it is linked to...

I have an inventory spreadsheet that is excel based and written in with VBA that want to make a standalone executable. The spreadsheet uses userforms for input and then transfers the input data to a diaphragm/floor plan, indicating what is in what room. I would like suggestions on what...

Hi, After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not...

I hope someone can help with an annoying problem. While editing an Excel 2007 Spreadsheet with information from Yahoo Finance, the Excel window looses focus. This usually happens in the middle of editing a cell. I generally have only the IE - 10 window and the Excel window open when this...

hi, All; I have MS Office 2010 Home Edition. Is there a way to make 2 different Excel docs show up on 2 different monitors at the same time (one on each, of course)? (I have a PC and 2 displays total.) Thanks!

Hello, I own an XP computer and on a spreadsheet in it, I have all of my work info for the last 15 years entered. I transferred all my info to the new Win 7 computer, but the spreadsheet desktop links don't work and I can't figure out any way to get to them. I hope there is a simple solution. I...

I have a 20 year Diary in Excel 2010 which I spent over 1,000 hours on. It is complex. I have over 5,000 lines and over 15,000 cells which are all color coded and fonts coded. Because of the complexity of the spreadsheetI have to do everything manually. I can't go and correct any fonts are color...

I have Excel 2010 I have a Diary which has 5,000+ cells(20 years) I want to do a "Find and replace" Find all the words inthe spreadsheet and change them to the font and color I want. However when I dothis and I change the color and Fonts the entire cell. At least half of mydiary is color coded...

I had about 15 files saved as File0000.chk through File0014.chk. PLEASE CHANGE CATEGORY IF I POSTED IN THE WRONG SECTION. First I tried renaming them with the likely extensions I use most often, such as .xlsx and .docx respectively for Excel and Word. This successfully recovered over 1/2 of my...

After doing a copy and paste, we have, on 3 occasions so far, found the copied data in an entirely different file. Twice data from a copy appeared in an excel spreadsheet and once a picture copied in facebook appeared in an email. The excel problem is very worrysome as it is our family budget...

There was an error in sending the fax. The error can be because of different print re OS: Win 7 64-bit -- new install less than 1 month -- all updates ran When using Windows Fax and Scan most faxes are able to go out. There is a certain Spreadsheet that cannot consistently be sent. This has...

I'm not sure if this is a W-7 problem, but I do not have this problem on my other XP computers. On my W-7 computer (and my others) I use MS Works 4.5. Anyway, when I load a word processing file (extension .wps) in Works and then save it to a DIFFERENT directory, it always appends a .doc to...

When I download an Excel spreadsheet in Win 7 64bit, Excel 2007 cannot read the spreadsheet. If I download the same spreadsheet on a XP machine with Excel 2007 I can read the spreadsheet.

hi there, could someone advise how i get out of compatibility mode... I am working on a spreadsheet in excel and cant do anything... thank you so much...

I upgraded to Vista Home Basic about 3months ago and I loaded Office 2007 onto this laptop about 3 weeks ago and a very sinister problem has just begun with Excel 2007 only. Excel 2007 was working fine until I started receiving an error message when try to open a spread sheet... the error...