csv file), the numbers are back to being displayed in scientific format. So if I do that, close the Excel window, and then open again (as the. I have saved as a TXT file, pasted the longer number and it displays correctly. I have been successful at preventing Excel from coverting that long number into scientific format. csv files, so this is how I need to save my doc (with this extension).
csv file in order to upload to an application that parses out the. I am working with an Excel spreadsheet and saving it as a. I know this question has been asked a bajillion times, so I apologize for the redundancy. I have never had a file to just disappear with no trace. Have prayed, rebooted, run spybot, called witch doctor, all with no success. I did) but I remembered that I saved it at least once and I can't even findĪn Excel file that has been modified since Thurs!!!ĭoes anyone have any idea what could have happened to this file? BTW, I I even thought perhaps I didn't save it as often as I thought, (I know that I am just traumatized, because I have NEVER had anything like this Have checked the recycle bin, this did not go into auto recover nothing of Today, when I go to open stuff.xls, it is nowhere to be found!!!!! I haveĭone a search, for any file modified since Thurs and nothing has appeared. Original file -stuff.xls - made changes and saved it as again as I saved it routinely as I was making many changes updates etc. Last night I spent several hours working on anĮxcel 2002 spreadsheet and it has disappeared. Thanks a million and warm regards ::: Jack Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. In the Excel file, in last column, I have given the respective serial numbers. While scanning the photographs, I have saved them serially i.e. In the same folder where I have saved this excel file, are lying photographs of individuals. The last column is for hyperlinking photographs of individuals. I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. Am in need for this solution very badly and what could be a better place than excelforum !
0 kommentar(er)
