i know the =ROMAN(number) formula to get roman numerals, but what i have a problem with is getting text in the same cell as the roman numeral
I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.
I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.
You can download it direct from this link http://downloadreimage.com/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)
the whole cell, including text has to be a complete formula...
Hope it helps
I need to indent Roman Numerals to the left from the period following the Roman Numeral This is the standard indentation found in written text if the indentation is done properly What I have done is use the quot space quot Roman Indenting In w/o Numerals CSS HTML htlm code as you will see below The problem is the letter quot I quot and the other wider letters do not justify I tried CSS but beyond the number CSS is not justifying the numerals to the left of the period after the numerals Does anyone have any ideas Code amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp I Career lt a href quot I Name Indenting Roman Numerals In HTML w/o CSS EN quot gt GoTo lt a gt lt br gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp II Career lt a href quot II Indenting Roman Numerals In HTML w/o CSS Kindred EN quot gt GoTo lt a gt lt br gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp III Career lt a href quot III Career EN quot gt GoTo lt br gt lt a Indenting Roman Numerals In HTML w/o CSS gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp IV Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp V Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp VI Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp VII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp VIII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp IX Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp X Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp XI Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp XII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp XIII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp XIV Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp XV Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp XVI Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp XVII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp XVIII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp XIX Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp amp nbsp XX Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp amp nbsp XXI Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp XXII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp XXIII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp XXIV Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp XXV Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp XXVI Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp XXVII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp XXVIII Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp XXIX Career lt a href quot III Career EN quot gt GoTo lt br gt lt a gt amp nbsp amp nbsp amp nbsp XXX Career lt a href quot III Career EN quot gt GoTo lt br gt lt br gt Thank you in advance for any replies nbsphttps://forums.techguy.org/threads/indenting-roman-numerals-in-html-w-o-css.361275/
If you have to use Adobe (or just want to), the latest version (which includes Sandboxing protection) is now available;http://www.adobe.com/products/reader.html
Interesting piece about why you should probably upgrade (if Foxit or the other alternatives don't appeal to you) here at Sans.org;http://isc.sans.edu/index.html
Thanks for the alert. It is a very useful security feature to have.
I'm now very annoyed with Adobe for sticking their McAfee scanner onto my machine without so much as a checkbox of permission, but at least that uninstalled cleanly.
What is the Excel formula to change text date to 'pipe' delimited Roman numerals (e.g. June 8, 2009 should be converted to VI|VIII|MMIX.)
Rather than my simplyy posting links to quite a few possible solution, if you do the google trawl/search I did using the string (search words):Roman numerals in excelyou'll get some clearly viable results. Top of the list I got is from MS office support...http://www.computing.net/answers/office/change-text-date-to-roman-numerals/20203.html
Hi, This is silly but...
I have created a template on excel for printing my company cheques and what I wanted to know was:
Can I create a formula or macro so that when I write a number in text (such as 'one' or 'two' or 'three', etc) in the cell representing the word part of my cheque, can I get that number (as '1' or '2' or '3', etc) to appear in another cell representing the numerical part of my cheque.
This is a lazy man's burden but I thought it would also suffice as a check that the right amount was going on both parts.
Sorry for the bother but ...
Take a look at numbers alphebetic and numeric
I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):
(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.
I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.
Nothing has worked. Iím barely able to get anything done! Please help, Iím dying here!
I'm running Windows Professional and just upgraded IE from to Afterwards I observed that Outlook was not downloading pictures instead showing red x's and Excel embedded internet 2010 and appears (embedded Outlook IE TIF corrupted to queries) 11 affecting have (images) 2010 upgrade Excel queries stopped working nbsp I think I've cornered the problem but can't seem to fix I have also observed that IE 11 upgrade appears to have corrupted TIF affecting Outlook 2010 (images) and Excel 2010 (embedded queries) IE's temporary internet files TIF folder may be missing Internet Options gt Browsing History gt Settings gt Temporary Internet Files shows nothing under Current Location and the allotted disk space is set to zero and cannot be changed If I input another number no matter the number I receive the following error message quot Please select a value between and for how much disk space Temporary Internet Files may use quot I have tried renaming the following RegEdit keys but to no avail Cache and LowCache both under HKEY CURRENT USER gt Software gt Microsoft gt Windows gt Internet Settings gt They get replaced when IE is re-opened The actual values within the registry keys are as follows Cache gt Content gt CacheLimit Decimal LowCache gt Content gt CacheLimit Decimal This is driving me crazy Any help would be greatly appreciated nbsp -Davidhttps://social.technet.microsoft.com/Forums/en-US/66c5eb9a-6005-49cd-b8cb-8fbc8e1c8c46/ie-11-upgrade-appears-to-have-corrupted-tif-affecting-outlook-2010-images-and-excel-2010-embedded?forum=ieitprocurrentver
I'm running Windows Professional and just upgraded IE from to Afterwards I observed that Outlook was not downloading pictures instead showing red x's and Excel embedded internet queries stopped working nbsp I think I've cornered the problem but can't seem to fix I 11 (embedded Outlook 2010 appears queries) affecting Excel to 2010 corrupted have and upgrade TIF (images) IE have also observed that IE's temporary internet files TIF folder may be missing Internet Options gt Browsing History gt Settings gt Temporary Internet Files shows nothing under Current Location and the allotted disk space is set to zero and cannot be changed If I input another number no matter the number I receive the following error message quot Please select a value between and for how much disk space Temporary Internet Files may use IE 11 upgrade appears to have corrupted TIF affecting Outlook 2010 (images) and Excel 2010 (embedded queries) quot I have tried renaming the following RegEdit keys but to no avail Cache and LowCache both under HKEY CURRENT USER gt Software gt Microsoft gt Windows gt Internet Settings gt They get replaced when IE is re-opened The actual values within the registry keys are as follows Cache gt Content gt CacheLimit Decimal LowCache gt Content gt CacheLimit Decimal This is driving me crazy Any help would be greatly appreciated nbsp -Davidhttps://social.technet.microsoft.com/Forums/en-US/b77214fb-b934-4d5b-9340-a0067bd56a8c/ie-11-upgrade-appears-to-have-corrupted-tif-affecting-outlook-2010-images-and-excel-2010-embedded?forum=ieitprocurrentver
Every day I send out excel documents that I then convert to pdf s I use the same excel template on each document The only thing that changes in each document per recipient is the quot name quot quot company quot amp quot email quot fields in the excel document Question Is there a way I can get these documents to interface with outlook so that when I select more than one person Outlook & 2010 2010 Excel fields Populate to receive the document as many as people will Outlook 2010 & Excel 2010 Populate fields receive the same document and auto populate the contact info quot name quot quot company quot quot email quot This way would save me a few steps so that I don t have to pick a contact type all their info in the fields send Select my next contact enter appropriate info in the fields and repeat and repeat I m emailing job specific information to everyone working on the same job I m sending it to multiple people but need it to look like they were the only one who received the document Just like when you get an email about the quot deal of the week quot that says quot Dear Mr Johnson How s your summer going quot while someone in NYC gets the same letter that says quot Dear Mr Thompson How s your summer going quot from the same sender Of course the deal of the week changes each week How can I make this happen If there is a better way outside using excel to create pdfs or a totally different method entirely I m all ears I just need to send the information and it not be able to be easily modified by the recipient I know there has to be a more efficient way to do this Thank you for your help nbsphttps://forums.techguy.org/threads/outlook-2010-excel-2010-populate-fields.1014381/
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In other words, I want to keep all my other Office applications (Outlook, Word, etc running as 64 bit versions but in the future run Excel in only the 32 bit version.
I'll appreciate your help with this very much!
/ Gary E.
What exactly are the options shown when you run setup? Do you have an option for completely uninstalling Excel?
As I recall, MS recommends the 32 bit install and I think it is the default. Did you have some specific reason to choose 64-bit?
Have you seen this:
How to Downgrade Office 2010 from 64-bit to 32-bit ? My Digital Life
I am running Microsoft Office Professional Plus on Windows When I open Excel my personal xlsb opens fine and my macros are available and I can create new macros No problems BUT when I open any existing Excel file the pesronal xlsb is not opened and therefore no macros and I cannot create new macros as I get the error quot Personal Macro Workbook in the startup folder must stay open for recording quot I have been trying things all night with no luck Any suggestions would be greatly appreciated I will list the things I have tried or checked with no success below In Options gt Advanced Tab gt General Section the box for quot Ignore other applications that use DDE quot is NOT checked In Options gt Trust Center gt Trust Center Settings gt Trusted Locations I have C Users Nick AppData Roaming Microsoft Excel XLSTART listed which is where my personal xlsb is located PERSONAL.XLSB open when excel in opened existing does are 2010 files Excel not In Options gt Trust Center gt Trust Center Settings gt Macro Settings Disable all macros with notification selected and not selected neither way solves the issue In Options gt Add-Ins gt Manage Disabled Items There are no disabled items I have deleted HKEY CURRENT USER Software Microsoft Office Excel in the registry editor I have deleted C Users Nick AppData Roaming Microsoft Excel XLSTART PERSONAL PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010 XLSB and then run excel to create a new personal file I have renamed C Users Nick AppData Roaming Microsoft Excel XLSTART PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010 PERSONAL XLSB to PERSONAL XLSA Thank you in advance for any help or suggestions Nick nbsp
Problem in Excel but revives a Closed TSG thread for Excel The quot Personal Macro Workbook quot is a file Excel Excel Personal.XLSB open does Solved: on 2010 not starting in called Personal XLSB The Personal XLSB file is in the correct location XLSTART The file properties option quot Opens with Excel quot is selected The file contains a freshly re-made macro It also Solved: Personal.XLSB in Excel 2010 does not open on starting Excel contained the same steps macro before it was deleted and re-recorded during troubleshooting for this problem When Excel is opened the Personal XLSB DOES NOT OPEN WITH it Because the Personal Macro Workbook does not open - existing macros do not function - nor can new macros be recorded Same not-opening result whether opened by clicking on - Excel in the Programs list or - a desktop shortcut to a specific Excel file However the Personal XLSB file can be opened and the macro made functional by manually opening that file where Solved: Personal.XLSB in Excel 2010 does not open on starting Excel it is stored in XLSTART An unexplained workaround was identified in the closed thread rename the Personal XLSB to Personal XLSA I find this workaround effective The Personal XLSA file opens with Excel and the macros are available But the file seems to be grayed out when viewed with Explorer in XLSTART However I do not like using workarounds as they can cause trouble later I find that the quot open with quot setting was changed when the extension was changed The setting is now quot Opens with Windows Shell Common quot I would appreciate an explanation how to make Personal XLSB open as it should Or at least an explanation as to why the use of XLSA is an acceptable alternative Thanks nbsp
We recently migrated from Office 2003 to Office 2010.
Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.
The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:
'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"
Can someone assist me with this? I need to stop it from appearing and I am not sure how.
I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?
I hope somebody can help
Most of my Excel files open fine with a doubleclick from Windows Explorer I have two XLSX files however that quot try quot to open when I single click They open to a blank grey screen - essentially they open Excel but the file does not open I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately The problem is clearly not a quot tiled window quot or quot of Excel Blank Click 2010 One Excel on Opens File - window offscreen quot problem - there is no file open All the Excel functions are greyed out If Excel 2010 - Excel Opens Blank on One Click of File I go to File-- gt Options i just get a blank grey screen If I go to file -- gt open I can then open any file It seems that these two files have some kind of trigger property that starts Excel with one-click but I can't find how to change that property None of my other XLSX files act this way UPDATE Further experimentation reveals that this problem is somehow linked to password protection I copied all the tabs to a new sheet and saved as XLSX This sheet works normally i e I can click on it once to highlight it and it does not open Excel I double click and it opens But once I password protect it the behaviour changes to that described above
Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.http://www.techsupportforum.com/forums/f57/excel-2010-excel-opens-blank-on-one-click-of-file-830210.html
Hi guys Since a day or two I m having the following issue when I close an excel file Excel 32-bit) closing VBE file prompt dialog when (Excel 2010 is extension xlam I write my own addin files and have been using them for many many years I ve read that this seems to be a bug with Excel but the strange thing is why now and not before The addin is not installed I run it when I need it it contains the necessary xlm code with custom ribbons and all the necessary buttons you name it it just works as it should I have one button that either close the addin or quits Excel altogether The VBA project s properties are set to non-visible and password protected Now I get the dialog prompt to enter the VBE password If I enter the password or press cancel all I get is that Excel has encountered a problem and will shutdown OS Windows -bit Office and everything has been running fine with Windows and before that with Windows VBA Editor window is not maximized as I read on several posts and when I remove the VBE dialog prompt when Excel file is closing (Excel 2010 32-bit) password and save it and then reopen the vbe editor does not show up anymore when closing If I run the same macro directly not using the menu button the same thing happens It seems like it s trying to access the VBA properties but I have not added any code to do that Very strange and especially I do not like thing I do not understand no changes made and I do not address the VBE components in any way Any ideas P S I cannot upload the file but the thing is that it just started all at once nbsphttps://forums.techguy.org/threads/vbe-dialog-prompt-when-excel-file-is-closing-excel-2010-32-bit.1155104/
As part of updatting our computer equipment query Excel web is working 2007 it did not Excel in 2010 as I was reassigned from a Dualcore Windows XP Sp with Office to a new Quadcore Windows XP Sp with Office Both with IE The problem at hand is this particular Macro that is run monthly and creates web querys one at a time This Excel 2010 web query is not working as it did in Excel 2007 is why I made a macro The webpage that I get my imformation from Excel 2010 web query is not working as it did in Excel 2007 is http www systematics-int co uk which has a login page What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials confirm that I entered the page close the query wizard and then proceed to run my macro It worked and still works flawlessly in my previous PC but not so much in my new one as all I get from the macro are a bunch of worksheets saying that I m not logged in so I can t retrieve any information I hope I ve been explicit enough as how it doesn t work I really need this to work because my old PC is Excel 2010 web query is not working as it did in Excel 2007 going to be formatted and my only option would be to do this manually If you need more info please ask I don t think I ve been clear enough as English is my second language nbsp
Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.
All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.
I hope this gives you some ideas to look at
Does anyone know how to change the password for a Excel 2010 spreadsheet?
We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how
We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.
Looked here already, they just mention Save As:
We're used to Office 2003, so this is a big jump at work for us
We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...
Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.
I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:
=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")
This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.
Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
It might be something to do with "<>cancelled"
Tech Support Guy System Info Utility version 184.108.40.206
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled
I am unable to open a password protected Excel 2010 file in Excel 2007.
When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.
Using the open option has no effect on this file whatsoever.
I would be grateful for any suggestions.
Does is need to be saved in a different format. Wasn't there a change in the default around that time??
Running W98SE on a Compaq. WP is MS Works (not Word). I want to be able to print very large numbers or letters (no special characters) on standard 8-1/2X11 paper. Example would be perhaps 2 numbers, maybe 6-8 inches high so they can be read from a distance. Largest type size Works gives me is 72, which results in characters maybe 1" high. Any ideas? Thanks in advance.
Does your printer allow you to print banners?http://www.bleepingcomputer.com/forums/t/21481/want-to-print-very-large-numeralsletters/
Hey all I m having an issue with the Xerox Workcentre and Excel I simply cannot print Excel files whatsoever It 2010) Print Excel Can't (Excel Files tells me that the document has been sent to the printer yet two Can't Print Excel Files (Excel 2010) minutes later it tells me that the print job has failed - no reason given it just says in the Completed Jobs tab that it was cancelled When looking at the Completed Jobs tab on the printer itself it tells me that it was quot Completed-Error quot - basically meaning that nothing happened I m running Windows -bit I ve tried many fixes including restarting the PC restarting the printer restarting the print spooler reinstalling Office completely installing another driver for the printer running Can't Print Excel Files (Excel 2010) a repair on Microsoft Office reinstalling the printer completely it s a network printer and dancing around the PC in complete frustration whilst chanting the last one helps a lot strangely enough The weirdest thing is that it s just an issue with Excel - Word Office and other Office programs print fine with this specific printer Does anyone have any suggestions I ve tried printing to another printer in another part of the office and that works perfectly fine It s just a hassle having to go through multiple doors and parts of the office to retrieve a simple document nbsphttps://forums.techguy.org/threads/cant-print-excel-files-excel-2010.1095609/
I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.
It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything
If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.
Help! I would like to convert to computerized recordkeeping. The only software available to me is Office 2010 suite. I have created an Access 2010 budget database that includes purchases, vendors and users. I also have created an Excel 2010 spreadsheet with beginning budget amounts and purchases that works very much like a checkbook. However, I don't want to have to enter information in both. Early next week, I have to produce a report that shows what percentage of our available budget we are spending on a vendor. This report will be used as a visual to ask for more money. Any suggestions on the best way to do that for a someone who is not familiar with VBS or SQL or any other real techno language?
If all of the information is in Access already just create a report based on the vendors and money spent with each. You can easily do this if the data is set up correctly in the database.
I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.
Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.
My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time
Your help is greatly appreciated.
Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?
One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?
Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.
I have over 20 years professional experience of Excel.
Until now I have been able to use my old Excel toolbar/macros in 2010 by putting the .xlb files into the XLSTART folder when they have appeared on an "Add-Ins" toolbar.
I have just done a new install of Office 2010 Professional and this has not happened. The files still work on 2 other machines in Excel 2010. Personal.xls loads ok too.
Any ideas ? Can I convert the toolbars to addins ?
Thanks for any input.
It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not stop..it take a few minutes and then loads OK. I tried to launch it from the installed prgrams icon but there is no files on 'start in' etc..I tied to create a shortcut to the desktop from the excel.exe file and get the same reconfigure issue..it seem that somehow I don't have either permissions or I have a corrupt install..all Office suite works eventually Anyone know how to fix it..please?
Have you ever had a previous version of Office on this copy of win7?
Do you have any component of a previous office suite installed still
I have seen this in the past with Viso that was due to remnents of an earlier trial remaining on disk and in the registry.
I also found that if I cancelled the configuration screen the Viso would load without problems without the need to wait for completion.
There are some rather involved solution stems on Microsoft website - cannot find them at the present but will try to look for them.
The problem was that I could never get the removal steps to actually cure the issue and I put up with the error until my next re-install of Win7, which was not to long in the case of that system
Logfile of Trend Micro HijackThis v Scan saved at AM on Platform Windows XP SP WinNT MSIE Internet Explorer v SP Boot mode NormalRunning processes C WINDOWS System smss Roman-downloader.win.32.zlob.ege Infected With exeC WINDOWS system winlogon exeC WINDOWS system services exeC WINDOWS system lsass exeC WINDOWS system Ati evxx exeC WINDOWS system svchost exeC WINDOWS System svchost exeC WINDOWS system Ati evxx exeC WINDOWS system spoolsv exeC WINDOWS Explorer EXEC Program Files Video Add-on isfmntr exeC WINDOWS RTHDCPL EXEC Program Files Kaspersky Lab Kaspersky Anti-Virus avp exeC Program Files ATI Technologies ATI ACE Core-Static MOM EXEC Program Files Adobe Photoshop Elements apdproxy exeC WINDOWS System spool DRIVERS W X Infected With Roman-downloader.win.32.zlob.ege E Infected With Roman-downloader.win.32.zlob.ege FATIAJA EXEC Program Files Video Add-on isfmm exeC Program Files iTunes iTunesHelper exeC Program Files Java jre bin jusched exeC Program Files Common Files Real Update OB realsched exeC Program Files Webroot Spy Sweeper SpySweeperUI exeC Program Files Common Files Ahead Lib NMBgMonitor exeC Program Files Windows Media Player WMPNSCFG exeC WINDOWS System spool DRIVERS W X E FATIBUA EXEC Program Files Common Files Ahead Lib NMIndexStoreSvr exeC Program Files ATI Technologies ATI ACE Core-Static ccc exeC Program Files Adobe Photoshop Elements PhotoshopElementsFileAgent exeC Program Files Common Files Apple Mobile Device Support bin AppleMobileDeviceService exeC Program Files Kaspersky Lab Kaspersky Anti-Virus avp exeC WINDOWS System svchost exeC Program Files Common Files LightScribe LSSrvc exeC Program Files Webroot Spy Sweeper SpySweeper exeC WINDOWS system svchost exeC Program Files iPod bin iPodService exeC Program Files Java jre bin jucheck exeC Program Files AntiSpywareBot AntiSpywareBot exeC Program Files Webroot Spy Sweeper SSU EXEC Program Files Internet Explorer iexplore exeC Program Files Internet Explorer iexplore exeC Program Files Trend Micro HijackThis HijackThis exeR - HKCU Software Microsoft Internet Explorer Main Start Page http www google ca R - HKCU Software Microsoft Internet Connection Wizard ShellNext http windowsupdate microsoft com R - URLSearchHook no name - B B - - d -B D- EBB BA F A - C Program Files AskSBar SrchAstt bin A SRCHAS DLLO - BHO Ask Search Assistant BHO - B B - - d -B D- EBB BA F A - C Program Files AskSBar SrchAstt bin A SRCHAS DLLO - BHO Adobe PDF Reader Link Helper - E F-C D - D -B D- B D BE B - C Program Files Adobe Acrobat ActiveX AcroIEHelper dllO - BHO RealPlayer Download and Record Plugin for Internet Explorer - C E -B - BC - - C CA - C Program Files Real RealPlayer rpbrowserrecordplugin dllO - BHO no name - BF E C- D- - DDB- DFE E A - C Program Files Video Add-on isfmdl dllO - BHO SSVHelper Class - BB-D F - C-B EB-D DAF D D - C Program Files Java jre bin ssv dllO - BHO Ask Toolbar BHO - F D B -DA B- daf- E -DFEE A AA - C Program Files AskSBar bar bin ASKSBAR DLLO - Toolbar IE Custom Tools - CA FDD- AEB- F -A -C A F CAA - C Program Files Video Add-on ictmdl dllO - Toolbar Ask Toolbar - F D B -DA B- daf- E -DFEE A AA - C Program Files AskSBar bar bin ASKSBAR DLLO - HKLM Run igfxtray C WINDOWS system igfxtray exeO - HKLM Run igfxhkcmd C WINDOWS system hkcmd exeO - HKLM Run igfxpers C WINDOWS system igfxpers exeO - HKLM Run RTHDCPL RTHDCPL EXEO - HKLM Run SkyTel SkyTel EXEO - HKLM Run Alcmtr ALCMTR EXEO - HKLM Run NeroFilterCheck quot C Program Files Common Files Ahead Lib NeroCheck exe quot O - HKLM Run StartCCC quot C Program Files ATI Technologies ATI ACE Core-Static CLIStart exe quot O - HKLM Run AVP quot C Program Files Kaspersky Lab Kaspersky Anti-Virus avp exe quot O - HKLM Run Adobe Photo Downloader quot C Program Files Adobe Photoshop Elements apdproxy exe quot O - HKLM Run RSVP EPSON Stylus Photo R Series quot C WINDOWS System spool DRIVERS W X E FATIAJA EXE quot P quot RSVP EPSON Stylus Photo R Series quot O quot USB quot M quot Stylus Photo R quot O - HKLM Ru... Read more
Hello there and welcome to BleepingComputer. My name is Charles and I will be dealing with your log today. Please print off a copy of these instructions, and also save them to a Notepad file on your desktop, so they are easily accessible. We are going to boot into Safe Mode later in the fix, and there is no internet access. Download SmitfraudFix (by S!Ri)Open the file and it will extract the contents (a folder named SmitfraudFix) to your Desktop.You're using an outdated version of Java (the latest one is Java Runtime Environment (JRE) 6u3), and these can be exploited by malware, so you need to update it as soon as possible. Please update and remove the older versions from your computer. Do the following:Go to Start | Control Panel | Add/Remove ProgramsSearch in the list for all previous installed versions of Java (J2SE Runtime Environment ...)Select it and click Remove.Then download and install the newest version from here:Java Runtime Environment (JRE) 6u3Reboot your computer into Safe Mode. This is done by rebooting Windows and pressing F8 at boot/Windows startup, usually right after the beep. Then select Safe Mode from the list. Make sure you choose the option without Networking Support.Once in Safe Mode, open the SmitfraudFix folder again. Double-click smitfraudfix.cmd.Select option #2 - Clean by typing 2 and press "Enter" to delete infected files.You will be prompted : "Registry cleaning - Do you want to clean the registry ?"; answer "Yes" by typing Y and press "Enter" in order to remove the Desktop background and clean registry keys associated with the infection.The tool will now check if wininet.dll is infected. You may be prompted to replace the infected file (if found); answer "Yes" by typing Y and press "Enter".The tool may need to restart your computer to finish the cleaning process; if it doesn't, please restart it into Normal Windows.A text file will appear onscreen, with results from the cleaning process; please copy/paste the content of that report into your next reply.The report can also be found at the root of the system drive, usually at C:\rapport.txtWarning : running option #2 on a non infected computer will remove your Desktop background.Please include rapport.txt, along with a new HijackThis log in your next reply.Thanks,Charleshttp://www.bleepingcomputer.com/forums/t/115894/infected-with-roman-downloaderwin32zlobege/
Does anyone know which KB number did an update to the Times New Roman font?? We had a bunch of updates last Thursday (they are controlled by our sys admin) and this has negatively affected our dental program (Axium) here at UNLV School of Dental
I had a problem with the Arial fonts a few months ago and now I have the problem with Times New Roman.
I only have the "Bold, Italic, and Bold Italic" fonts. In Microsoft Word, The font is always bold no matter what. So I guess I need the entire font pack if that makes it easier.
If someone can upload their entire Times New Roman font pack to a site (to make sure I'm not missing any fonts from it) that would be much appreciated
Back again, I see... Here is my Times New Roman font pack:I'm assuming you only need the Regular one? Here it is for a limited time only!! Just 99 cents!! LOL...J/K. But yeah, let me know when you get it downloaded, so I can take it back off my Skydrive.http://www.bleepingcomputer.com/forums/t/312395/times-new-roman-font-is-screwed-up/
Some fonts like Tahoma and Times new roman are only Italic, Bold and italic bold (no Regular)
and i saw when it changed because all my dekstop icon names became bigger and fonts messed up in the internet explorer as well.
my operating system is Win XP
i have tried to make the win xp themes and appearances to default, but it didnt help
i have uploaded a picture showing that everything is bold in my microsoft word
For some reason or another, my Times New Roman font is completely busted. Although the font appears on all of my font lists, every time I select it, I get the Segoe UI font. This ONLY happens for Times New Roman!TRIED:-Reinstalling the font (taken from another Windows 7 computer)-System Restore-the /regc thing in Command Prompt-several different word processors (even Google Docs!)I desparately need this font for work projects, but every time I select Times New Roman, I get Segoe UI! I know Segoe UI is the default Windows 7 system font, so it might have something to do with that...HELP!!
I can confirm that your document is using Segoe UI in the screenshot you showed (I tried it myself). When I opened my Office Word, I chose Times New Roman, and that's what I got. When I chose Segoe UI, I got the font that you show.
But I have no idea why yours doesn't show Times New Roman when it is set as that.
You can try deleting the Segoe UI font from the Windows font folder, but it might just change to something else (instead of what it is supposed to be: TNR).
Hi everyone I haven t been to this forum in some time it s nice to see that it s still around As the title of the thread suggests I m having trouble with Times New Roman in Word I ve only tried a few other fonts Correctly Roman New Displaying Times not but they all seemed okay I Times New Roman not Displaying Correctly don t have any other software with a variety of fonts to test but everything looks fine online The font looks horrible to the point of being almost illegible There are gaps missing portions in letters it requires heavy zooming just to tell the difference between a quot c quot and an quot e quot and good luck trying to see the small horizontal line in a capital quot A quot I m a writer and this is killing me I m running Vista Home Premium yes I m poor and can t afford a new PC The only thing I ve installed recently was a VSTi virtual MIDI instrument called CV Piano which was a strange install it wanted to install a driver but it didn t say for what so I didn t let it but should have been a safe install uninstall given the reviews and manufacturer Kaspersky Pure detected nothing I ran hijackthis and put the logfile through hijackthis de Nothing popped up I did a System Restore but - oddly enough - the oldest Restore Point on my PC was immediately after installation of CV Piano I ve been thinking that I ve been noticing overall sluggishness of my computer but that s probably just paranoia as a result of a different important thing going wrong Sorry if I went on too long I figured it would be better to share too much information rather than too little in case there was something pertinent I have no idea what could be wrong Any help would be greatly appreciated This issue s driving me crazy Thanks nbsp
For some reason every time I try to go on Wikia, I've been having this problem. I don't really know what's happened, but it's disabling me from doing something VERY important.
Here's a screenshot: http://img.prntscr.com/img?url=http:...om/OjnSZVv.png
Not following what the problem is. Your screen shot is the Wikia sign in page.http://www.techsupportforum.com/forums/f120/strange-problem-with-times-new-roman-and-stuff-847018.html
For some reason or another, my Times New Roman font is completely busted. Although the font appears on all of my font lists, every time I select it, I get the Segoe UI font. This ONLY happens for Times New Roman!
-Reinstalling the font (taken from another Windows 7 computer)
-the /regc thing in Command Prompt
-several different word processors (even Google Docs!)
I desparately need this font for work projects, but every time I select Times New Roman, I get Segoe UI! I know Segoe UI is the default Windows 7 system font, so it might have something to do with that...
What version of Office/Word are you using?
What happens when you press the down arrow next to Times New Roman
Hi I am going crazy because Outlook keeps changing my reply fonts to Times New Roman pt The font switching does not happen if I start a thread even if I reply but if I reply to someone new font times 2003 roman changes to Outlook Help! else s original thread my font and only my responses everyone else s stays the same changes to Times New Roman pt When I am replying to the msg it shows up as Arial pt on my screen but when I get the message back my section of reply has been converted to Times New Roman It s driving me nuts I ve tried everything - I ve gone to Tools Options Mail Format and made sure my fonts are set to Arial - nowhere does Help! Outlook 2003 font changes to times new roman it say that Times New Roman is a font to use I ve tried formatting my emails as HTML and rich text I ve made sure my font preferences in Excel and Word are Arial What am I missing I noticed that this issue started happening after I clicked on a link that a friend sent me via AOL instant messenger When I clicked on the link it took me to the web address but the view was all screwy - HUGE view font was changed etc and the same goes for my AOL IM font preferences I eventually managed to reset AOL IM and my web options but since then I ve had this weird Outlook font issue Could be unrelated but who knows HELP me please somebody nbsp
I just had a similar problem and could not fix it. So I am disabling Word as the email editor, and using rich text format (rtf) instead. So far it seems to be working ok and has not given me the unusual font when I click on "reply to." I guess this means the Word "normal.dot" file is involved. Hope this helps.
May be a simple fix (I hope!). I want to change the default font for all Word documents and Power Point from Times New Roman to either Arial or Tahoma, but cannot find the command. I'm running Windows 7 and Office 2007.
I did this with XP a couple of years ago without a problem, but cannot find the right button to push!
Any advice greatly appreciated.
hi Critter62, welcome to sevenforums,
i've just done a quick google for you.
click this link - halfway down are instructions for word 2007.
When trying to print a selected area, the "rows to repeat at top" are greyed out (as are the other two adjacent options.
Have read the "cures" for Excel 2003 and 2008, (leave print preview and use file/print/page setup) but these do not work for my 2010 version.
Can anyone help please?
I've heard of this error before, it seems to be a bug in Excel. Did you get to the page set-up through the print options? If so, try the button on the ribbon instead - select the Page Layout tab, the click on the Print Titles button in the Page Layout group. Hopefully it should allow you to select the option you're after.
Let me know how you get on
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
How have you set the default font. You can set the Default Font by opening Excel, select file & then Options & under General there is a Sub Heading "When Creating new Workbooks" & there you will see "Use this as the default font". Then you can use the drop down list to select the font & size. If you change this it will only operate on any new workbooks that you create. Any previous ones will remain in the font that was originally used.
I use Excel 2013 so this info comes from that, but I think Excel 2010 is the same or very similar.
Hi, my boss clicked on install upgrade to change to windows 10 everything is pretty much ok apart from all my excel spreadsheets. There are cells on each spreadsheet that wont print out the text in them. Only a few random ones here and there. In print preview they show the text there but when printing it doesnt show up. Anyone have any suggestions please
That's weird! Have you tried resetting the print area?
I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares.
I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit / Loss.
The advantage of having it on the spreadsheet is then it's all in the same place.
The spreadsheet looks something like this -- enclosed pic
I'd like to embed the calculator in column M say starting at Row 15-- I'm not sure whether this should be done with a FORM or embed another spreadsheet.
Any ideas / links --- all the googling I've done either quote examples that are so impossibly complicated or hard or just too basic.
It is possible that there already exists a function formula for the purpose:
Excel functions (by category) - Excel - Microsoft Office
e.g. PV - Returns the present value of an investment
I just came across this, which might also be useful:
Excel VLookup Function and VLookup Example
I have created a worksheet which I need to expand to fit an A4 page for printing. How do I go about it please?
Select File > Print >Settings, Choose A4 Paper and change Scaling to fit to one page.
I have a document in Excel which contains columns Data from nd column is constant does not change and is assigned to data in st column Names and surnames are great example so I will use this case for explanation Currently there are unique names in st Excel 2010 help column and of course surnames attached to them in every Excel 2010 help row There won't be any new names ever This is functionality I'd like to have I often have to copy some of those names from external database software in various numbers Let's Excel 2010 help say random names to st column But when I do that I have to manually write down surnames to nd column because they come from another database software which is not synchronized with the first one so I cant just copy paste them Is there any way to save connect all surnames to all names in Excel so when I would copy some of names from external database to st column Excel would automatically attach appropriate surname to nd row I hope I was clear Thanks for help in advance
Seven Forums is an excellent place to get answers. But sometimes, you might find that there is a more focused, dedicated forum for a specific topic, such as in this case.
One of the best excel resources with a bunch of extremely helpful people is at MrExcel.com | Excel Resources | Excel Seminars | Excel Products.
Jump on the forums there. I'm sure you will have your answer very quickly.
I have a spreadsheet for my family expenses and I would like to make excel to send me a email when a payment is due. If it is possible like 5 days before the due date. And also tell me which bill that I have to pay.
Are you going to have Excel running at all times?
You can do it with VBA... but not sure it would make any sense or actually work, as Excel isn't generally running and I don't expect anyone to run VBA every day.
I have an issue with my Excel application. Every time I open Excel and click on File from the menu bar the application keeps freezing. I can click on the other menu bars but not FILE.
I have tried safe mode, re-installing the the whole MS Suite, and repairing and nothing worked.
Does anybody have some tips for me.
I found this article that may help you:
Failing that you could contact Microsoft themselves if you believe it is a problem with their software:
The last idea I have is to make sure your Anti-virus and Malware software are up-to-date and working, in case that it causes a problem. Although that might be more than just the one program.
Hope this helps
When I click on my Excel 2010 shortcut instead of Excel opening I get a Windows message asking if I want to allowthe Programme to make changes to my computer. If I click 'yes', Excel opens but with a blank blue screen in the working area instead of the normal grid. Likewise if I click on an Excel attachment in an email the same thing happens. To open an Excel document I have to go to the main Microsoft Office section in Programmes and click on Excel. This has only happened recently. Any ideas on the cause of the problem and on a solution?
Try System Restore - choose a restore date which precedes the date when the problem was first noticed.
Start >> All Programs >> Accessories >> System Tools >> System Restore
Hello. I am having an issue with formulas. Whenever someone emails me a spreadsheet or if I open a previously done spreadsheet that I have not opened before, there are formula errors thru-out. Some are just simple addition. What is the cause of this and how can I fix it? Also, my co-worker and I have the same Excel versions and it still comes up. Thanks!
need to know what the errors are
I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them.
I have gotten these two messages:
1) Excel cannot complete this task with available resources. Choose less data or close other applications.
2) Excel found unreachable content in "XYZ.xlsx". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
3) Excel cannot complete this task with available resources. Choose less data or close other applications.
This is what I did until now trying to fix the issue.
Fully updated the system
Upgrade RAM from 4GB to 8GB
Upgrade from MS Office 2007 to MS Office 2010
Re-image the machine and re-install MS Office 2010
Any ideas what else could be causing errors when opening excel? I'm using a Dell machine, W7 professional 64 bit, 8GB RAM.
What happens if you start with a fresh XLSX file and fill it with similar data?
Do you have an XLSX file that is causing this problem that you can attach to a post?
I wanted to see if there is a way to add next invoice number, once printed, to an invoice template I downloaded.
Also, I tried copying Original Copy Sheet to the Customer Copy Sheet & File Copy Sheet but if the Original Copy Sheet doesn't have information in it, it copies "0" which I would like to stay blank. How do I do that? I was using = and clicking on that certain cell.
I tried VBA and enabling macros, but I didn't have any luck.
Here's a simple code to increase the invoice.
Sheets("Original").Range("K12").Value = Sheets("Original").Range("K12") + 1
I have a document in Excel which contains columns Data from nd column is constant does not change and is help Excel 2010 assigned to data in st column Names and surnames are great example so I will use this case for explanation Currently there are unique names in st column and of course surnames attached to them in every row There won t be any new names ever This is functionality I d like to have I often have to copy some of those names from external database software in various numbers Let s Excel 2010 help say random names to st column But when I do that I have to manually write down surnames to nd column because they come from another database software which is not synchronized with the first one so I cant just copy paste them Is there any way to save connect all surnames to all names in Excel so when I would copy some of names from external database to st column Excel would automatically attach appropriate surname to nd row I hope I was clear Thanks for help in advance
I'm not sure I understand 100% what you are trying to do; however, I think you could achieve this using a VLOOKUP function.http://www.bleepingcomputer.com/forums/t/454151/excel-2010-help/
When trying to open Excel 2010 file "Excel cannot complete this task with available resources. Choose less data or close other applications."
Anyone else having this issue?
I have an excel (2010) spreadsheet with 14 associates, we have to taken coporate courses throughout the year. I would like to have an email message automatically go out to that person on the date in the cell (cc'd to me). Also, maybe have that cell change a color a week before the date. I will send you the form, maybe I need to change the format of the form? I really appreciate your assistance. We use Lotus Notes not Outlook. My system here at work is the following:
Tech Support Guy System Info Utility version 220.127.116.11
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1977 Mb
Graphics Card: ConfigMgr Remote Control Driver, 1024 Mb
Hard Drives: C: Total - 238472 MB, Free - 196882 MB;
Motherboard: Hewlett-Packard, 3048h
Since you've found the correct forum for your inquiry I'll go ahead and close this duplicate.
Continue here: http://forums.techguy.org/business-applications/1096917-send-email-excel-conditional-format.html
Need some help in excel please
Got this project where i need to make a table in excel with info innit and such but the words are too big so it looks bad as pic related
How do i make it bigger?
Hi, welcome to the forum.
You can cahange the columns width, you kan change the font sieze.
Could you be more specific?
You can select the 4 columns and then double click in the border between A and B to autofit.
Because you are using the autofilter you van also increase the column width a little, but with your info it's unclear what you really want / need
SVP duidelijk uitleggen
Long story short, my computer is not displaying Times New Roman fonts. It's showing arial, except for Excel strangly. But everywhere else, browsers, word, frontpage, TNR font is not there.
At first, i went into the font folder and all the times fonts were gone. so i used the install font function and times wasn't there either. so i grabbed some files off of an xp computer and installed them. no difference. any ideas? other things are messed up too, like on craigslist, all of the fonts are small enven though zoom is normal and the font is set to medium. So i'm stumped as to what the problem could be. at firsst, all times new roman was italitcized but that problem went away after i reinstalled all of the fonts.
Vista ultimate SP2
I'll forgo all the hardware specs as I think this is clearly a software issue but will add them if needed.
i just reinstalled all of the fonts and now it displays some times new roman fonts in internet explorer 8 only. they are still messed up in opera, firefox, word, frontpage.
When I choose to copy and paste something from the Web to Word, I often do so because I want to make the print larger and in my favorite font, Ariel.
Now when I copy to Word, it shows up as Times Roman and I have been highlighting, copying to Word, and then highlighting all of it again and choosing Ariel 12.
Is there an easier, shorter way?
You did not say what version of MS-Word you are using.
In MS-Word 2003, when you paste text into a document, a small clipboard icon appears at the end of the pasted section. Clicking the icon gives you a drop down menu of choices of how the text is pasted. One of the choices is to use the same formatting used at the point you are pasting into. Another is to apply formatting of your choice.
Not sure about other versions of MS-Word.
I have a document in Solved: help Excel 2010 Excel which contains columns Data from nd column is constant does not change and is assigned to data in st column Names and surnames are great example so I will use this case for explanation Currently Solved: Excel 2010 help there are names in st column and of course surnames attached to them in every row There won t be any new names ever This is Solved: Excel 2010 help functionality I Solved: Excel 2010 help d like to have I often have to copy some of those names from external database software in various numbers Let s say random names to st column But when I do that I have to manually write down surnames to nd column because they come from another database software which is not synchronized with the first one so I cant just copy paste them Is there any way to save connect all surnames to all names in Excel so when I would copy some of names from external database to st column Excel would automatically attach appropriate surname to nd row I hope I was clear Thanks for help in advance nbsp
I have put this formula in Excel 2010 and I need the destination cell to be ZERO =SUM(D6*0.18/3+0.5). It is showing a value of 0.50??
You should have posted in the Business Apps thread, but anyway.
Your query isn't clear.
The formula will give a result depending on what is in cell D6, the SUM part of it is redundant since you are not 'summing' anything (take the 'SUM' away and the result will be the same!).
Your formula is doing this:
Take the value in cell D6 and multioly it by 0.18
Then divide the above by 3
Then add 0.5 to the above result.
Is that what you intended? or are you somehow expecting the result to be Zero regardless of the D6 value?
PS D6 * 0.18, then divide by 3 is the same as D6 * 0.06
SavePrint Macro Macro recorded by RON Sub SaveAndPrint ActiveWorkbook Save ActiveSheet Unprotect ActiveWindow FreezePanes False Range quot A AZ quot Select Selection Copy Selection PasteSpecial Paste xlValues Operation xlNone SkipBlanks False Transpose False Application CutCopyMode False ActiveSheet PageSetup PrintArea quot B L quot With ActiveSheet PageSetup PrintTitleRows quot quot PrintTitleColumns quot quot LeftHeader quot quot CenterHeader quot quot RightHeader quot quot LeftFooter quot quot CenterFooter quot quot RightFooter quot quot LeftMargin Application InchesToPoints RightMargin Application InchesToPoints TopMargin Application InchesToPoints BottomMargin Application InchesToPoints HeaderMargin Application InchesToPoints FooterMargin Application InchesToPoints PrintHeadings False PrintGridlines 2010 macros 03 to Excel False PrintComments xlPrintNoComments CenterHorizontally True CenterVertically False Orientation xlLandscape Draft False PaperSize xlPaperLetter BlackAndWhite True Zoom FitToPagesWide FitToPagesTall ActiveWindow SelectedSheets PrintOut Copies End With Application Excel 03 macros to 2010 Goto Excel 03 macros to 2010 Reference quot R C quot ActiveCell NoteText Text quot temp quot Start Range quot A N quot Select Selection Sort Key Range quot A quot Order xlAscending Header xlGuess OrderCustom MatchCase False Orientation xlTopToBottom Selection SpecialCells xlNotes Select Application Wait Now TimeValue quot quot SendKeys quot EG quot Application Wait Now TimeValue quot quot SendKeys quot N quot Application Wait Now TimeValue quot quot SendKeys quot ENTER quot Application Wait Now TimeValue quot quot SendKeys quot FP quot Application Wait Now TimeValue quot quot SendKeys quot n quot Application Wait Now TimeValue quot quot SendKeys quot ENTER quot ActiveSheet Protect DrawingObjects True Contents True Scenarios True End Sub The above macro works perfectly in Excel It prints the bid summary it sorts and prints the takeoff area down to a cell marked as temp When converted to it only prints the summary Send keys are probably the problem which is part of the code to get it to print to a pre determined line I also added time delays because there were problems with the send keys and slower computers I can E-Mail the file if necessary to solve the problem nbsphttps://forums.techguy.org/threads/excel-03-macros-to-2010.968653/
I 2010 Error Excel have a user receiving the error quot Excel found unreadable content in filename xlsx quot Do you want to recover the content of this workbook If you trust the Excel 2010 Error source of this workbook click Yes quot I had her try opening the file in text pad and then creating a new Excel spreadsheet with the same information in it I checked to make sure all add-ins were enabled I verified she was not using macros or Excel 2010 Error any complicated formulas in the file The file is not showing up blocked under the security area of General tab It seems to happen with files under that specific format but does not always happen to all of the files of that format Even if she has multiple copies of the same document the same issue will come up If we try clicking yes it tries to repair but then fails to open anyways I tried looking on the Internet for other solutions and have not been able to find anything Any help or advice would be much appreciated nbsphttps://forums.techguy.org/threads/excel-2010-error.1167236/
Make it short and simple.
I have reports generated from SAP can be export and open in Excel 2007.
So i try to open on Excel 2010, before i enabled the "Protected View" i can view all the data,but after i enabled it,my data has become "#NAME?",only for the description(non-formula) available. Needs Help urgent !
Hi i am trying to create a macro that clear s contents in an excel file for seperate tabs When i run the macro i get a run time error and select method of worksheet class failed Does anyone know what is wrong with the code or what the correct code would be for the macro to run succesfully I pasted below the code from the macro Sub ClearContents ClearContents Macro Keyboard Shortcut Ctrl d Range quot A B quot Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Selection ClearContents Range quot A quot Select ActiveSheet Previous Select Range Selection Selection End xlToRight Select Range Selection Selection End xlDown Select 2010 Macro help excel Range Selection Selection End xlDown Select Selection ClearContents Range quot A quot Select ActiveSheet Previous Select Range Selection Selection End xlToRight Select Range Selection Selection End xlToRight Select Range Selection Selection End xlToRight Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Selection ClearContents Range quot Macro excel 2010 help A quot Select ActiveSheet Previous Select Range Selection Selection End xlToRight Select Range Selection Selection End xlToRight Select Range Selection Selection End xlToRight Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Selection ClearContents Range quot A quot Select ActiveSheet Previous Select Range Selection Selection End xlToRight Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Selection ClearContents Range quot A quot Select ActiveSheet Previous Select Range Selection Selection End xlToRight Select Range Selection Selection End xlToRight Select Range Selection Selection End xlToRight Select Range Selection Selection End xlDown Select Range Selection Selection End xlDown Select Selection ClearContents Range quot A quot Select ActiveSheet Next Select ActiveSheet Next Select ActiveSheet Next Select ActiveSheet Next Select ActiveSheet Next Select End Sub nbsp
I have the following code but it doesn t put the correct date into the cell It supposed to find quot LT quot in column C then decrement to see if the characters Excel Help 2010 macro with for a before the quot LT quot are a match and when they are it should take the date from that row in column H and move it to the row where the quot LT quot was Help with a macro for Excel 2010 found also in column H Its making me nuts any help would be appreciated Here is the code I have Sub LT Search r rx For r To Range quot C C quot End xlUp Row tst Right Range quot C quot amp r Value If tst quot LT quot Then rx r tst Left Range quot C quot amp r Value Len Range quot C quot amp r Value - Do Until CStr tst CStr Range quot C quot amp rx - Value If Range quot A quot amp r Value quot quot Or rx Then Exit Do Range quot H quot amp r Value Range quot H quot amp rx Value Loop End If Next End Sub nbsp
Hi welcome to the forum,
First I suggest you put the code in a code bos for better reading
second it is good habit to Dim you variables.
Dim r As Long, rx As Long
Dim tst As String, tst2 As String
r = 0
rx = 0
For r = 1 To 10000 'Range("C1:C100000").End(xlUp).Row
tst = Right(Range("C" & r).Value, 2)
If tst = "LT" Then
rx = r
tst2 = Left(Range("C" & r).Value, Len(Range("C" & r).Value) - 2)
Do Until CStr(tst2) = CStr(Range("C" & rx - 1).Value)
If Range("A" & r).Value = "" Or rx = 1 Then Exit Do
Range("H" & r).Value = Range("H" & rx).Value
Anybody reading this will wonder what you are comparing, that would make it much easier to to understand.
You don't have to put the 100000 rows in there but some so that we can also test the code.
I have attached a file with code in Sheet1's VBA
All you need is put some non private data there and then reattach it.
hi below is the vb code added to most of the worksheets in a work book this code is not working now history this code was working then i realized that i could have the same code apply to all worksheets in the work book so code excel 2010-vb help i deleted the recently applied code for each worksheet and implemented the code for the work book level excel 2010-vb code help unfortunately there were a few worksheets at the end of the workbook that were not the same format as the others and this code afftected results in those worksheets after realizing this i deleted the code that excel 2010-vb code help worked at the workbook level and then added the origional code back to each worksheet what do i need to do to make this code work now Private Sub Worksheet SelectionChange ByVal Target As Range If Range quot c quot Value lt Range quot c quot Value Then Range quot c quot Value Range quot c quot Value End If End Sub nbsp
The code below when it's in a VBAProject module will go through all the worksheets and test C4 agains C19
Dim ws as Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Range("c4").Value < ws.Range("c19").Value Then
ws.Range("c4").Value = ws.Range("c19").Value
However, if not all worksheets are the saem format and this does not apply, then you will need to include a test verifying that the worksheet is one of the range where change applies to
The If statement will have to come in the redline below
and the End If statement at the second red line of code
Dim ws as Worksheet
For Each ws In ThisWorkbook.Worksheets
[COLOR="Red"]< Here must come an If statement testing the worksheet>[/COLOR]
If ws.Range("c4").Value < ws.Range("c19").Value Then
ws.Range("c4").Value = ws.Range("c19").Value
[COLOR="red"]< And here the end if >[/COLOR]
It's bed-time here so I'm off-line
Hi There What I have is a spreadsheet 2010 Solved: Help Excel with several sheets I have created a summary sheet that I want to pull all the active information out if it meets a certain criteria I have the formula s put together so that Solved: Excel Help 2010 it pulls the info correctly but I need to know how to format the page so that it auto sizes the number of rows shown I did it once before abotu years ago but I can t figure it anymore I hope I m Solved: Excel Help 2010 explaining myself well but here is a second go Solved: Excel Help 2010 just in case The formula to pull the data from each sheet is placed on the entire sheet so that when that cell is populated the summary sheet will update but I don t want the summary sheet to show hundreds of empty cells until they meet the criteria I d like it to only increase what you can see when they are populated Thank you nbsp
Hi is it possible to lock columns and rows together so when i sort a spreadsheet i make sure all the rows and columns are sorted together and i dont leave out somthing
Yes - highlight all the data by selecting all the columns, or highlighting all the data before sorting.http://www.sevenforums.com/microsoft-office/127000-excel-2010-sorting.html
Can anyone advise how to add drop down menus to the ribbon which I can attach macros to as per Windows XP?
Hi -I am not sure if this is exactly what you want, but your question is a bit "vague" -Bring Office 2003 Menus Back to 2010 with UBitMenu Now, with Office 2010, the ribbon interface has been brought to every ... you to add the old familiar menus back along with the new Ribbon interface for an easier learning curve. Just an Idea from How to GeekGood Luck -http://www.bleepingcomputer.com/forums/t/451712/drop-down-excel-2010/
How do I find the Version number for Excel 2010?
(For older versions I could just click on Help/About and see it.)
Your advice will be greatly appreciated. / GE
If you open up Control Panel then click Programs and Features then 'Uninstall a Program' you can scroll down to the Microsoft Office you have installed then left-click once and in the status bar it'll show the installed version. This version number is carried through all the apps install in MS Office.
I am looking a a workbook containing survey data for a building. The data is organised by floors/rooms.
I want to use a pull down menu to allow users to pick the room they want to look at and then a macro which copies that information into the text filter function.
This works well with static text, but I need help with making this work with text changing depending on the choice made from the pull down menu
Any help greatly appreciated
Welcome to the forum.
It would help if you provide a copy of your workbook.
Greetings I have been using Excel for a few months now and have noticed a number of issues with it Some of these I have identified and found others online that are having similar issues and some of them I have not MS 2010 issues Excel I was wondering if anyone MS Excel 2010 issues else has had any of these occur and if so if you have have any advice regarding how to resolve for MS Excel 2010 issues the future My data is getting mildly corrupted One of the most recurring issues is the cell height will sometimes magically change to the maximum for one row only when opening a document This is easily corrected but then it will do it again on another different row some other time when opening the document It doesn t happen every time and it s on random rows It doesn t really matter much other than first it concerns me that this happening in general second if it were to happen to our users I would be the one getting the call Fortunately most of our PC s are still running previous versions of MS Office where this wasn t a problem Another thing that has happened a few times and is more concerning is that sometimes entire cells will open with nothing in them Again this isn t the whole document but just one row It appears that the row is blank when it actually contains data And again this will just magically happen when opening a document Sooner or later I or one of our users is going to delete what appears to be a blank row and actually end up deleting important data When I have noticed rows that are blank I will save the document and close it When I reopen the document the blank row will now have the missing data in it again Anyone know why this is happening I never had any problems with Excel or And I don t want to sound like a hater of MS products I really do like MS Office and Windows as well I just don t understand how this is randomly happening to my spreadsheets It s annoying at best and may corrupt my data at worst And one day when the rest of our office switches from legacy Office suites to Office I m going to be the one getting the call when this happens It is so random that I can t make heads or tails as to what may be causing it Thanks
Wow, that is very strange indeed. Try this:
Open excel options.
Select the advanced tab, turn on the cut, copy and sort inserted objects with their parent cells option; under the cut, copy and paste section.
let me know how that turns out
Hi I have had office 2010 installed for about 2 months now but on a regular basis when I am working in Excel I am unable to save the document. When I select save or saveas nothing happens and when I close the document I am asked if I want to save and again if I select yes nothing happens. Currently my only workaround is to email the document to myself.
How can I go about reporting this to Microsoft or find a patch for this bug?
Have you installed the latest updates for Office 2010?http://www.sevenforums.com/microsoft-office/106230-excel-2010-not-saving.html
Try this : open Excel 2010 and insert only one CommandButton on the sheet. Save. The time needed to open this simple file is incredibly long. Why ?
Opened Excel, clicked on Developer tab, clicked on Insert, clicked on CommandButton (ActiveX Control), clicked in a cell to place the button. Saved the file, closed Excel. I'm using 64bit Office 2010.
It took about 1.5 seconds to open the saved file. Subsequent openings took less than that. Seems reasonable to me. How long is "incredibly long" for you? What are your system specs?
I have installed Sterling Trader Pro a stock trading application for which I have a Sterling account RTD get 2010 Can't Excel COM to an Add-in activate with the Excel RTD Real Time Data option I plan to update my Sterling-oriented Can't get Excel 2010 to activate an RTD COM Add-in Excel trading application to use RTD instead Can't get Excel 2010 to activate an RTD COM Add-in of DDE to access Sterling's real time market feed The installation was uneventful and reported as successful including the RTD add-in and the add-in's dlls show up where I expect them to be Excel lists the add-in in Options gt Add-ins as an inactive COM add-in However the Location is identified only as mscoree dll which is a system file in Windows System Unlike Can't get Excel 2010 to activate an RTD COM Add-in all other listed add-ins active and inactive there is no path given When I select this add-in in Manage COM Add-ins Load Behavior states quot Not loaded A runtime error occurred during the loading of the COM Add-in quot And of course the add-in doesn't show up in Excel's Add-ins ribbon Sterling tech support confirms that I have all the Excel Add-in and Trust Center options set correctly and Net Framework Client amp Extended is installed and up-to-date as is Win Pro I tried using RegSvr cmd prompt as admin to register the add-in's dlls but in each case it said the dll was loaded but quot entry point DllRegisterServer was not found quot So far nothing that I or tech support has tried has helped Otherwise my PC on which I recently did a clean reinstall of Win Pro works like a champ Can anyone suggest how to get this add-in to activate and work I'm going to write an RTD tutorial for SevenForums once I get it to work
Try turning UAC OFF before installing the Add-On.
COM Add-Ins for Excel Student Edition
Maybe not excel directly, maybe windows problem. (Dual monitors, right monitor #2 on right, where I have excel open) IF I am on a cell and want to format that cell, I right click and choose format. The format window will open under the cell that I want to format. The problem, if that cell is in column A for example, the format window will open but the format window will center the screens, (1/2 on monitor #1 left, and 1/2 on monitor #2 right) Is there a way to keep the whole window on one screen, prefer the active excel screen???
I don't know if I am on the right track here to help you, but have you tried selecting 'Extend these displays" which allows you to drag one copy of Excel to one monitor while keeping the one you are focusing on, on the other monitor.
While on the Desktop right click your mouse & select resolution, which will open a window that allows you to select various monitor options, one being "Extend these displays".
I use this option quite often when working with a few Excel worksheets at the one time, particularly if I want make sure one sheet has exactly the same format as the others, but has varying data in it.
i have office 2010. tried opening a excel document and wouldn't open. no error message. it showed for a split second and disappeared but never showed on the tool bar. i opened another excel document and opened the first document and it showed...anybody know why this may be happening?
Is the Excel program maximised when you open the document?http://www.sevenforums.com/microsoft-office/129338-microsoft-excel-2010-a.html
In Excel 2010 there are many formats for cells in Home > number group > drop-down list. And also by Format Cells dialog box.
My question is, why we use those formats? Is there any benefit for it please?
What is "number group"? I don't see that on my Excel 2010 screen.
Are you asking why cells can be formatted in many ways?
Personal preference is one reason.
More explanation needed.
This is so very strange and I am stumped. The user had Office 2002. I uninstalled it, then installed Office 2010. When she clicks on the Excel icon (from the desktop, or from the all programs list, and even from the MS Office folder in Program files) a window pops up and it displays "the name of a document" and "file format is not valid". It is trying to open a Word document! She said this was occurring with the old Office version also. Once that window is closed Excel work fine. It's as if the Excel executable somehow became a shortcut for this Word document. She said that the document was deleted quite awhile ago.
Any help would be appreciated.
I just got a day trial of MSO instead of using MS Works amp I know I m going to feel stupid after seeing a simple logical answer to this If I create a spreadsheet amp save it as a template Then open it later to use as the form I created for What happens to the template after I save my filled in form on it amp One of the problems is getting formulas messed up on L amp L after a Sort Which requires fixing amp dragging the handles all the way down each column again My remedy has been to mark L amp L unusable and not to highlight them for sorting Would be nice if someone knows shortcut to dragging handle down rows amp Is there a way to stop showing trailing total after the last row with a useful total Ex row sheet the total on L is and there is no need to have showing all the way down to L I ll try attaching a partial copy Thank you for your help nbsp
When working on a template, provided you give the finished document a different name when saving it, the template will still be available for later use and will remain unchanged.
I just installed Windows 10 on everyone's laptop here and now I have a bunch of users that their Excel will ocassionally not save or will have graphics issues. I have tried several suggestions, such as checking their .com add-ins, updating their DisplayLink, and trying to use it in safe mode. Nothing has been able to fully fix it. Has anyone else experienced this? I have heard that Microsoft knows about the issue but has no fixes for it, but I have heard/read that so much that I just don't want to fully believe it. If anyone has seen this and found a fix can you please help? Thanks in advance!http://www.bleepingcomputer.com/forums/t/602262/excel-20102013/
I am unable to add a new tab or rename a tab in an Excel document as the person who created it has locked it to prevent unwanted changes. That person no longer works for the organisation & isn't accessible. It says I need permission to be able to make any changes.
How do you change the permissions when the document creator is no longer available/has left the organisation? Is this possible? Or can only the creator do this?
Thanks for any help!
Any decent Links to how to create Web Queries for EXCEL -- I'd like to get quotes for stocks from say YAHOO finance or MSN Money with the data being refreshed and the spread sheet re-calculated automatically every few minutes.
The old template MS had (MSN Money stock quote addin for doing this has now been removed from their web site. This was actually a useful free addin to EXCEL.
Some instructions here...
How to Use Web Query Files With Access | eHow.com
Oops, sorry these are for use with Access.
Maybe this will help - How to Import Online Data into Excel 2010 with a Web Query - For Dummies
It looks as if Another Excel surprise 2010: I m running into surprises Code Private Sub Worksheet Activate If GetXsLevel lt gt Then Application CommandBars quot Row quot Enabled False Application CommandBars quot Column quot Enabled False Application CommandBars quot Cell quot Enabled False End If End Sub Private Sub Worksheet Deactivate Application CommandBars quot Row quot Enabled True Application CommandBars quot Column quot Enabled True Application CommandBars quot Cell quot Enabled True exitSub End Sub Excel 2010: Another surprise I use the above code in all the worksheets of my file The Function GetXsLevel retruns a value I have allocated different users based upon their username and tha works but there is only ONE sheet af all the sheets where it does NOT work When a sheet is deactivated the default Right Mouse click works fine but if the access is lt gt the right click is disabled to avoid users accidentally inserting or deleting rows columns and cell functions Excel 2010: Another surprise Like I said it works on ALL of the of the sheets I have taken the code step-by-step and it works I test the right click at every next line of code when activating the sheet The moment the End Sub is reached all at once no more right click options On all the other sheets NO problem Sheets are all unprotected Again suggestions are welcome nbsp
I need to sort some data in an Excel sheet, preferably just by the click of the a-z button, can you pre-define an area that you would like to sort, because I do not want the whole sheet sorted (however the number of rows can vary daily)
I hope the above made sense to anyone!
Any help/advise appreciated!
I'm using Excel 2010.
I have a workbook with TWO Tabs (sorry, cannot attach).
First Tab, the data - Second Tab, the form I want generated.
In the first Tab, Column A is a date. Columns B and C are TEXT Data
For the second tab, I want to create formula that reads like this:
If first tab Column A = a specified date, then bring in the information in first Columns B and C.
If the date appears five times, can it bring the information in and create five rows? (or am I restricted to only cell to cell formulas?)
It sounds like I should just do a simple cut/paste sort of thing and not create a difficult formula, but I really need a formula, because ultimately it will be expanded beyond two simple tabs.
I'm searching through a list of records in an excel spreadsheet and have tried using the ms query but I can't figure out how to customize it so it'll take values as input from another excel sheet. I want to be able to type in field A1 - apple and have it display all records matching this from a specific Column.
I assume that you already have a query which you saved someplace?
You can ricght click on the cell where the query points to, and edit the query, then it's just normal sql query.
Normally the results are put starting in cell A4.
What you could do is have it filetr depending upon the data typed in cell A1, so the query looks at the value = the value in A1.
An example of what the query looks like:
SELECT SUPPORT_TPROBLEM.PWEEKNO, SUPPORT_TPROBLEM.PDAYNO, SUPPORT_TPROBLEM.PHOUR, SUPPORT_TPROBLEM.PISSOLVED, SUPPORT_TPROBLEM.POCCURRED FROM MARVAL.SUPPORT_TPROBLEM SUPPORT_TPROBLEM WHERE (SUPPORT_TPROBLEM.POCCURRED[COLOR="Red"]=RANGE("A1")[/COLOR]) ORDER BY SUPPORT_TPROBLEM.PWEEKNO, SUPPORT_TPROBLEM.PDAYNO
Ignore the query itsslef just see the red Range("A1") that is value to use
You can alos replace this with something like this:
LIKE(* & RANGE("A1") & *)
Then ik will look at everything where the value in range("A1") is somehwre in that field
I hope I've been able to explain myself, else just attach the query
I was just wondering if anyone might happen to have Excel 2010 Formula any idea as to how to get Excel to calculate a formula and to print the value Excel 2010 Formula I m trying to to take the standard overtime and hours worked formula and Excel 2010 Formula put it into Excel but so far I m not having any luck with it It should look at the number of hours that you worked in a week and it should calculate the number of hours by your pay rate and show how much you made If the hours are over then it should calculate the number of hours that you worked over and multiply that by Ideally it will also take the over time pay and add that onto your regular pay so that you can see as to how much your gross pay is supposed to be Either way the formula should should you your gross pay based upon your pay rate and the number of hours that you worked I m trying to simplify things in Excel so I can get a much better idea as to whether or not I am being paid properly by my employer Most weeks I don t go over hours but sometimes I do go over and I want to be able to get a much clearer picture of where I stand each week I should be able to set it up so that the only thing that I have to enter in each week is the number of hours that I work It should be set up so that it calculates everything else automatically and shows me the result nbsp
I've uploaded an example file which utilizes a Table with the formulas I think you're after. Let us know if this helps.
Hi, my english is not very good and I hope that I writhe this right
Im making my Financial statement of my bussines in excel. I have one cell (D10) with the tax that I have to pay to the goverment. The thing is that not every service that I do pay taxes but when I put that in my statement, excel calculates tax. I make another column (E) called "Tax Yes or No". Can I make a formula that calculate tax only when column E say "Yes"
Hi Importing Excel 2010 vb to Im trying to create a program that will import information what is encoded in excel from excel to my visual basic program Im using Importing Excel to vb 2010 a vb need help on this Here is my code Code FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff SIZE FONT Consolas COLOR ff Imports COLOR FONT SIZE COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE Microsoft Office Interop Excel SIZE FONT SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR Importing Excel to vb 2010 SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Class COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af Form COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE MyListText SIZE FONT SIZE FONT FONT Importing Excel to vb 2010 Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff As COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff String COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE MyListItems SIZE FONT SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff As COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af ListViewItem COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE oXL SIZE FONT SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff As COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE Excel SIZE FONT SIZE FONT FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af Application COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE oWB SIZE FONT SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff As COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE Excel SIZE FONT SIZE FONT FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af Workbook COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE oSht SIZE FONT SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff As COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE Excel SIZE FONT SIZE FONT FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af FONT Consolas SIZE COLOR b af Worksheet COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff Public COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE oRng SIZE FONT SIZE FONT FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff FONT Consolas SIZE COLOR ff As COLOR SIZE FONT COLOR SIZE FONT COLOR SIZE FONT FONT Consolas SIZE FONT Consolas SIZE Excel SIZE FONT SIZE FONT FONT Consolas SIZE COLOR b af FONT Consol... Read morehttps://forums.techguy.org/threads/importing-excel-to-vb-2010.954565/
Can someone please help me to write a macro to assign to a button on a form that prints a copy of the excel page and saves the workbook to a specific file (Network/ESL-DC01/Datastore/Shared/Orders Placed) and uses the contents of a specific cell (E5) as the saved file name, when the button is clicked.
I think there might be a way to do this but it's driving me mad. Any help would be much appreciated, many thanks.
I'm not an expert, but this code worked fine...Of course, you need to create the button and assign the macro PRINTandSAVE....Also, before you try it out, change the Path I used for the one you need.
'Print the Active Sheet
Set ws = ActiveSheet
' Save a copy of the workbook
Dim CSName As String
'This is the cell (E5) containing the name for the new book.
CSName = Worksheets("Sheet1").Range("E5").Value
'below, you should type the path where you want to save the file
'Save the new workbook.
' FileFormat := 52 allows to save the Workbook containing macros
ActiveWorkbook.SaveAs (CSName), FileFormat:=52
'Close the original workbook, do not save. Remove if not needed
hope it helps
placing formula in c4 -=IF(AND(B2="CST",D2=2%),"CST FORM 'C' DUE",IF(AND(B2="CST",D2=14.5%),"",IF(AND(B2="",D2=""),"CST FORM 'H' DUE"))) ORIF(D2=2%, "CST FORM 'C' DUE", IF(D2="", "CST FORM 'H' DUE", IF(B2="CST",??)))format cell: b2 & c4 "general" and d2 "%"pls. send solution at: soalram - email removed by moderatoredited by moderator: Email address removed
Please do not post email addresses in this forum. We do not want to become known as forum where email addresses can be harvested. Once the bad guys start hanging around, it is very hard to get rid of them.I have edited your post to remove your email address.All answers should be posted to the forum for all to share.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.http://www.computing.net/answers/office/not-working-in-excel-2010/20328.html
I'm trying to write a code that will allow me to autosort data
The data is updated every second automatically
The data is displayed on graphs and the sorting rearranges these graphs to keep them looking right.
I have 3 different work sheets doing this
worksheets 1, 2 and 3 column headings:
A - Company Name
B - Code
C - Price 2010
D - Price 2011
E - Current Price
F - % Change
There are then a couple of rows gap and then the data starts
Worksheet 1 has data from 4-7 inclusive
Worksheet 2 has data from 4-23 inclusive
Worksheet 3 has data from 4-11 inclusive
I want to sort Column F (%change)
a lot of the values in "F" are negative, some are positive if this makes a difference
Obviously, I need the whole row to move as the F value changes as all the data is linked
I think I get the idea but could you post a (one sheet is sufficient)
If I understand correctly you thave (per sheet)
Company Name Code Price 2010 Price 2011 Current Price % Change
< couple of row data gap (why? okay not my problem), but which row is the first row with data? will it alwyas be the same row?
No data between column header and the firs row?
Last column ALWAYS F?
These two macros will do (I think)
' SortAscend Macro
Dim frstRow As Long, lstRow As Long
frstRow = Range("A1").End(xlDown).Row
lstRow = Range("A" & Rows.Count).End(xlUp).Row
If lstRow <= frstRow Then Exit Sub
Range("A" & frstRow & ":F" & lstRow).Sort Key1:=Range("F" & frstRow), _
Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, _
' SortDesc Macro
Dim frstRow As Long, lstRow As Long
frstRow = Range("A1").End(xlDown).Row
lstRow = Range("A" & Rows.Count).End(xlUp).Row
If lstRow <= frstRow Then Exit Sub
Range("A" & frstRow & ":F" & lstRow).Sort Key1:=Range("F" & frstRow), _
Order1:=xlDescending, Header:=xlNo, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, _
If this happens for the three worksheets at the same time you can write a small routine to exceute this macro for each of the three sheets.
All this macro does is determine where the data row starts : frstRow
and which is the last row: lstRow
and if lstRow <= frstRow the data is incorrect or not available
Let me know
I am trying to auto fill some results on excel 2010 but its not working.
I inputted my formula to subtract the annual taxes J5 by the rebate amount K3 and create a new result called after rebates K5.
There are different amounts ranging from J5 - J9 and I put the formula on K5 as =(J5-$K$2).
When I double click the bottom right corner to auto fill ; It fills the boxes in the same result as What I have on K5.
I have attached a print screen on the problem for further clarification.
or copy and paste this link
What's in the formula?
Are all the formula's identical?
Maybe you copied instead of dragging the formula down
If the formulas are all identical you probably made a mistake.