displays

Why isn't my name box working? For example, I highlight A1:B2, the name box briefly displays "2R X 2C", but as soon as I click on the name box to define the range, it defaults back to A1. If I've created a list of named ranges, when I click the drop down menu of the name box, it displays the...

Hi All I have a spreadsheet with multiple shapes Based on a selection i make - i hide a picture and display the relevant picture The problem im having is that the screen flickers before it displays the shape I have tried Application.screenupdating to false, turned off the calculation...

This should be a straight-forward question, but I haven't done Excel in a while, so maybe there is a kind soul here that can point me in the right direction ;) I have a table that displays distances between Points T, A, B, C, D, E, which looks like this: <tbody> T A B C D E T 0 22 20 51 59...

I have this number format to display gigabyte units after numerical values. #" GB" When I enter a value of 0 in a cell with the formating, the zero does not diplay. Only the " GB" displays. I would like "0 GB" to display. What is wrong with my number format? Thanks in advance! Don

Hello everybody, I would like to create a combo box in Word and depending on the value of the combo box (A, B, or C) that the text associated with the value displays on the word. (or excel 2010 but I would prefer Word 2010 if possible) For exemple I named my combo box "Choice" and inside there...

Hey all I have a cell B3 that is using an equation to reference another sheet. I need this cell to overflow into cell C3. This is a number, it displays correctly when in 99999 and under numbers, however, once I go into 100000 and over numbers it truncates to 1e+05. I cannot have this. Changing...

Hi guys I’m working on a sales tracker for work I’ve it a formula for a cell that when an option is picked from a drop down menu it displays a price However when no option is picked it currently displays #N/A and this is stopping my formula from calculating How can I get it to display a £0.00...

Hi all, Is there a way to have the username and date displayed together =username()&NOW() displays a number after the username Thanks for any help

Hi there I'm using an Excel spreadsheet as a database (mostly text based), so that in columns 1 and 2 are names and in column 3 is notes. I'm keeping all the columns single height (ie: not wrapping text). Where there is nothing in column 4 onwards, the text from column 3 displays across the...

Hey guys, I am working on an application for a monthly sports tournament that I run. There are three workbooks to this application: the Administration workbook, the Bracket workbook, and the Leaderboard workbook. I currently have a dual monitor setup (extended, not clone) with my laptop in...