Applications :: Excel - Number Hidden Beneath Cell's Displayed Text ... Possible?
Feb 21, 2010
Is there a way to have a cell display text, but behind the text is actually a number figure that I can ask Excel to use in calculations? I'll explain what I mean to give you a visual so you'll understand what I'm trying to do. I want to create a monthly budget in an Excel spreadsheet. I'll have one row for each day of the month, and maybe 3 or 4 columns for in which to put expenditures for each day.
Let's say on the 4th of the month I have a Visa bill due, I usually put gas in my car and I pick up some Dry Cleaning. I'd like to be able to type Visa, Gas and Dry Cleaning within the row of cells for the 4th, and have the dollar amounts for those expenditures hidden beneath the text. Then I'd do a summation formula in the last column to tabulate all of the hidden dollar amounts to give me a total for that day. This way, I can see a total expenditure figures for that day (in the summation column) and what the money went to, without having to do the spreadsheet the old-fashioned way of putting the Text in one cell and the dollar figures in an adjoining cell (which in this case wouldn't work in a columnar sense since the text cell would have to be either above the dollar cell, thus making the text cell in the previous day's row...or, putting the text in say, cell B2, and the dollars in row B3, and doing the same for multiple charges per day, which would make for a very wide spreadsheet.
In excel, whenever I try to type in a cell, I must press the first key 10-20 times before it shows up. It doesn't show up delayed, as in it shows up with 20 a's, it just shows one. Once the first key shows I can type anything else in that cell, but when i hit an arrow key or click to go to another cell, I have to hit the first letter 10-20 times again. I have to click 10-20 times to click into a new cell as well. This just started today. I've tried restarting excel a few times, but It didn't help.
I'm looking for a program/app that will allow me to primarily send SMS from my Mac using my current phone number. Does anyone know if anything like this exists? I can only think of something like this working in one of two ways: Sending an SMS composed on my Mac through my mobile/cell, via Bluetooth or some other method? OR Using software that emulates my mobile number to compose and send SMS?
I remember back in the day you could actually email an SMS to a phone by using their mobile number as a username and their network as the domain - e.g. 07123456789@orange.net. Unfortunately, because pretty much all the networks now provide email services too, doing that nowadays means they will actually receive an email at their online account instead of their SMS inbox.......................
Is there a wayof changing the color of the border of the active cell in excecl?
I have a very difficult time seeing the pale green. I waste a fair amount of time modifying formulae because I'm in the wrong cell. Making it a different color or making it more vivid, or bold, would be great.
Tried going into Apple preferences and Excel preferences, but did not have any luck. Maybe I just didn't do the right thing once there.
In some of my folders, the inside folders appear to be blank and have no text. When I click on the folder icon, the name of the folder is there, but there appears to be a hard return at the end of the text. When I delete the hard return, the text becomes visible.
Rather than go to each folder and do this - why this is happening, and how to correct all the folders wherever they may be on any disk.
I remember a while ago, there was a way to change how item info was displayed. there was a way to get rid of the word "free" and shorten the text line displayed. i was wondering if someone could refresh my memory.
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
After upgrading to Lion, I can no longer see the text in my word documents or excel worksheets. I know the text is there because it appears in the formula bar - it just isn't visible in the cells. I can also see the text if I quickview the excel files. In the word documents, all I can see are the pictures/images...no text. Weird. I have the latest version of Office 2008 and Lion OS.
I write reports and I use office for mac because at work I need to read the reports I write at home with macbook. I use tables on microsoft word that are connected to excel. When I click on them the excel opens to may introduce formulas and text. If I close excel the table I modified on excell lays on word with the rest of the text of the report. My doubt is when I add cells to the table on excel....I can't visualize them on word...
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
The v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
I would like to fill some cells in numbers conditionally with blank. These cells are in a table which is used to fill one chart. So I dont want the cells to have a value of zero. Alternatively, is there a function which returns the value in a cell?
I am working with a spreadsheet. I need to conditionally format a cell (a different color), if that cell is referenced in any other cell. I use iwork08.
I am trying to figure a way to notify me when I forget to enter data in specific cells, that need to be filled in. I included a screen shot. What I want it to show is basically fill in the whole row in red or another color. When I forgot to input data. Is there a formula?
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
In iWork 08's Pages application, I need a keyboard shortcut to edit the cell contents. Example: current cell contains the text "new client" -- I decide I want it to read "new clients" without typing it all over again. In Excel for Windows, I would hit F2, that would give me a cursor at the end of the word "client" and I was good to go.
get video recorded from my cell phone (motoroala Hint) imported into imovie so I can edit the video and merge clips. The file extension of the video file is .3g2 . Quicktime will play this video, but imovie apparently does not support it. I have found a number of different video apps by searching forums (iskysoft imedia converter, handbreak, mpeg streamclip, applemacsoft video converter) of which only iskysoft imedia converter does what I want to do. The only problem is the trial version does not convert audio and has "evaluation copy" imprinted into the video. The full version costs $50
At the moment I am open minded about Ping, so I might give it a try. But I do have a question.. For those who have activated an account.. Does it display your entire library of music you downloaded? Or does it just display who your favorite artists are and what your favorite songs are? I wasn't sure if you get to choose what or how info is displayed.
I've managed somehow to change the displayed bitrate of songs I've purchased off the iTS, simply by removing the contact details with a hex editor, and it's really bugging me that there doesn't seem to be any way to change it back!
Normally, iTS purchases appear as 256kbps, which is the standard I use (I don't have VBR checked for iTunes plus, as it appears '256kbps (VBR)' whilst songs purchased from iTunes do not, and I like 100% consistency in appearance) - however, now I am getting the true bitrate on songs I've purchased and altered, such as 264kbps, or 281kbps, anywhere from 256kbps to 290kbps.
How can I change the appearance of these files so iTunes displays them as 256kbps again? I've tried AtomicParsley, but it doesn't seem to have a bitrate option, and I definitely do not want to burn them to CD and rip them back!
I know this will sound like an incredibly anal request, but as I said, I like 100% consistency!
I just opened iPhoto and found that when I click on an "Album" (menu to the left), it just opens up with full size images. It used to display thumbnails and I'd need to click on the image to open it into full size. Is there some option that I inadvertently adjusted to cause this change?
I am using MBP Pro with OSx 10.7.3. I use admin account. Recently I enabled root account and then disabled it back again. Since then I am seeing applications only for root and not for admin even with admin login. If I go to /Users/<admin username>/Library/Preferences, I can see that the applications has relevant files over there. When I looked more carefully I observed that, I am able to see the applications installed for the root only and not for the admin user. Is there any way to corrrect this?
I have iPhoto 09 running on Snow Leopard and a Canon 50D DSLR. When I connect it to the computer using the USB cable, it does not show up under the devices item on the left side pane of iPhoto. I've tried changing USB cables as well as the USB slot to which the cable is plugged, but to no effect. The funny thing is if I select the option to automatically start iPhoto when a camera is connected, then iPhoto starts automatically when I connect the camera, but still the camera does not show up under devices. Occasionally, it does show up when I connect it, usually taking a long time to appear.
