can lookup return cell reference istead of "text" for sumif?

I am trying to use a lookup-function to determine a different sum
range for several criteria.
Like so:
=Sumif($A$7:$A$1447;"<"&X3;vlookup(e3;AT3:AU11;2;false)-Sumif($A$7:$A
$1447;"<"&y3;vlookup(e3;AT3:AU11;2;false)
The problem is that the vlookup returns text and not the cell
reference. Is there a way to get the answer from the lookup expressed
as cell reference instead of text, since sumif can't use text, just
the cell reference?

I use it to calculate the number of hours the staff should be paid, so
it's different from weekdays to saturdays, holidays and sundays
in at3 to at11 i have the days (1 for sunday) of the week and in au3
to au11 i have the ranges for the reference table with pay per minute.
1	sheet1!$E$7:$E$1447
2	sheet1!$C$7:$C$1447
3	sheet1!$C$7:$C$1447
4	sheet1!$C$7:$C$1447
5	sheet1!$C$7:$C$1447
6	sheet1!$C$7:$C$1447
7	sheet1!$D$7:$D$1447
holliday	sheet1!$F$7:$F$1447
eve	sheet1!$G$7:$G$1447

/Oslopelle
0
oslopelle (6)
4/26/2008 11:16:17 AM
excel 39879 articles. 2 followers. Follow

4 Replies
471 Views

Similar Articles

[PageSpeed] 13

Try wrapping the =vlookup() with =indirect(vlookup())

=Sumif($A$7:$A$1447;"<"&X3;indirect(vlookup(e3;AT3:AU11;2;false)))
-Sumif($A$7:$A$1447;"<"&y3;indirect(vlookup(e3;AT3:AU11;2;false)))

(aren't you missing some ()'s in your posted formula?

Oslopelle wrote:
> 
> I am trying to use a lookup-function to determine a different sum
> range for several criteria.
> Like so:
> =Sumif($A$7:$A$1447;"<"&X3;vlookup(e3;AT3:AU11;2;false)-Sumif($A$7:$A
> $1447;"<"&y3;vlookup(e3;AT3:AU11;2;false)
> The problem is that the vlookup returns text and not the cell
> reference. Is there a way to get the answer from the lookup expressed
> as cell reference instead of text, since sumif can't use text, just
> the cell reference?
> 
> I use it to calculate the number of hours the staff should be paid, so
> it's different from weekdays to saturdays, holidays and sundays
> in at3 to at11 i have the days (1 for sunday) of the week and in au3
> to au11 i have the ranges for the reference table with pay per minute.
> 1       sheet1!$E$7:$E$1447
> 2       sheet1!$C$7:$C$1447
> 3       sheet1!$C$7:$C$1447
> 4       sheet1!$C$7:$C$1447
> 5       sheet1!$C$7:$C$1447
> 6       sheet1!$C$7:$C$1447
> 7       sheet1!$D$7:$D$1447
> holliday        sheet1!$F$7:$F$1447
> eve     sheet1!$G$7:$G$1447
> 
> /Oslopelle

-- 

Dave Peterson
0
petersod (12005)
4/26/2008 2:04:56 PM
On 26 Apr, 16:04, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Try wrapping the =3Dvlookup() with =3Dindirect(vlookup())
>
> =3DSumif($A$7:$A$1447;"<"&X3;indirect(vlookup(e3;AT3:AU11;2;false)))
> -Sumif($A$7:$A$1447;"<"&y3;indirect(vlookup(e3;AT3:AU11;2;false)))
>
> (aren't you missing some ()'s in your posted formula?
>
>
>
>
>
> Oslopelle wrote:
>
> > I am trying to use a lookup-function to determine a different sum
> > range for several criteria.
> > Like so:
> > =3DSumif($A$7:$A$1447;"<"&X3;vlookup(e3;AT3:AU11;2;false)-Sumif($A$7:$A
> > $1447;"<"&y3;vlookup(e3;AT3:AU11;2;false)
> > The problem is that the vlookup returns text and not the cell
> > reference. Is there a way to get the answer from the lookup expressed
> > as cell reference instead of text, since sumif can't use text, just
> > the cell reference?
>
> > I use it to calculate the number of hours the staff should be paid, so
> > it's different from weekdays to saturdays, holidays and sundays
> > in at3 to at11 i have the days (1 for sunday) of the week and in au3
> > to au11 i have the ranges for the reference table with pay per minute.
> > 1 =A0 =A0 =A0 sheet1!$E$7:$E$1447
> > 2 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > 3 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > 4 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > 5 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > 6 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > 7 =A0 =A0 =A0 sheet1!$D$7:$D$1447
> > holliday =A0 =A0 =A0 =A0sheet1!$F$7:$F$1447
> > eve =A0 =A0 sheet1!$G$7:$G$1447
>
> > /Oslopelle
>
> --
>
> Dave Peterson- D=F6lj citerad text -
>
> - Visa citerad text -


unfortunatley i ony get an error message when trying to make an
indirect function. In swedish it comes out as ber=E4kningsbar -
calculable an the sumif won't accept that as a cell reference in the
sum range.
I now have:
Sumif(sheet1!$A$7:$A$1447;"<"&X3;vlookup(e3;sheet1!AT3:AU11;2;false))-
sumif(sheet1!$A$7:$A$1447;"<"&Y3;vlookup(e3;sheet1!AT3:AU11;2;false))

if e3=3D 4
the lookup would return the answer "sheet1!$c$7:$c$1447"


AT            AU
> > 1         sheet1!$E$7:$E$1447
> > 2         sheet1!$C$7:$C$1447
> > 3         sheet1!$C$7:$C$1447
> > 4         sheet1!$C$7:$C$1447
> > 5         sheet1!$C$7:$C$1447
> > 6         sheet1!$C$7:$C$1447
> > 7         sheet1!$D$7:$D$1447
> > holliday  sheet1!$F$7:$F$1447
> > eve       sheet1!$G$7:$G$1447
> >
the problem is that the sumif does not recognize that result as a cell
reference. it thinks it is text and the sumif returns an error.How do
i change this? it only needs to recognize the result as a range.

a contains a day in minutes, x is the beginning time of the empployee,
y is the ending time of the employee, c,d, e, f, g are the respective
compensation the emplyee gets for working that minute (double time=3D2,
150% =3D1,5, 133%=3D1,33 or normal time=3D1).

a is the day, 1 for sunday, 2 for monday and so on, au is a written
cell reference.

0
oslopelle (6)
4/26/2008 10:38:21 PM
It worked for me.

I don't have another suggestion--except for you to try it again.

You could explain where each range is--is the table on sheet1 or the sheet with
the formula?

And please copy|paste the formula you're using from the formula bar.  Don't type
it into the message.  Too many things can go wrong.

Oslopelle wrote:
> 
> On 26 Apr, 16:04, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > Try wrapping the =vlookup() with =indirect(vlookup())
> >
> > =Sumif($A$7:$A$1447;"<"&X3;indirect(vlookup(e3;AT3:AU11;2;false)))
> > -Sumif($A$7:$A$1447;"<"&y3;indirect(vlookup(e3;AT3:AU11;2;false)))
> >
> > (aren't you missing some ()'s in your posted formula?
> >
> >
> >
> >
> >
> > Oslopelle wrote:
> >
> > > I am trying to use a lookup-function to determine a different sum
> > > range for several criteria.
> > > Like so:
> > > =Sumif($A$7:$A$1447;"<"&X3;vlookup(e3;AT3:AU11;2;false)-Sumif($A$7:$A
> > > $1447;"<"&y3;vlookup(e3;AT3:AU11;2;false)
> > > The problem is that the vlookup returns text and not the cell
> > > reference. Is there a way to get the answer from the lookup expressed
> > > as cell reference instead of text, since sumif can't use text, just
> > > the cell reference?
> >
> > > I use it to calculate the number of hours the staff should be paid, so
> > > it's different from weekdays to saturdays, holidays and sundays
> > > in at3 to at11 i have the days (1 for sunday) of the week and in au3
> > > to au11 i have the ranges for the reference table with pay per minute.
> > > 1       sheet1!$E$7:$E$1447
> > > 2       sheet1!$C$7:$C$1447
> > > 3       sheet1!$C$7:$C$1447
> > > 4       sheet1!$C$7:$C$1447
> > > 5       sheet1!$C$7:$C$1447
> > > 6       sheet1!$C$7:$C$1447
> > > 7       sheet1!$D$7:$D$1447
> > > holliday        sheet1!$F$7:$F$1447
> > > eve     sheet1!$G$7:$G$1447
> >
> > > /Oslopelle
> >
> > --
> >
> > Dave Peterson- D�lj citerad text -
> >
> > - Visa citerad text -
> 
> unfortunatley i ony get an error message when trying to make an
> indirect function. In swedish it comes out as ber�kningsbar -
> calculable an the sumif won't accept that as a cell reference in the
> sum range.
> I now have:
> Sumif(sheet1!$A$7:$A$1447;"<"&X3;vlookup(e3;sheet1!AT3:AU11;2;false))-
> sumif(sheet1!$A$7:$A$1447;"<"&Y3;vlookup(e3;sheet1!AT3:AU11;2;false))
> 
> if e3= 4
> the lookup would return the answer "sheet1!$c$7:$c$1447"
> 
> AT            AU
> > > 1         sheet1!$E$7:$E$1447
> > > 2         sheet1!$C$7:$C$1447
> > > 3         sheet1!$C$7:$C$1447
> > > 4         sheet1!$C$7:$C$1447
> > > 5         sheet1!$C$7:$C$1447
> > > 6         sheet1!$C$7:$C$1447
> > > 7         sheet1!$D$7:$D$1447
> > > holliday  sheet1!$F$7:$F$1447
> > > eve       sheet1!$G$7:$G$1447
> > >
> the problem is that the sumif does not recognize that result as a cell
> reference. it thinks it is text and the sumif returns an error.How do
> i change this? it only needs to recognize the result as a range.
> 
> a contains a day in minutes, x is the beginning time of the empployee,
> y is the ending time of the employee, c,d, e, f, g are the respective
> compensation the emplyee gets for working that minute (double time=2,
> 150% =1,5, 133%=1,33 or normal time=1).
> 
> a is the day, 1 for sunday, 2 for monday and so on, au is a written
> cell reference.

-- 

Dave Peterson
0
petersod (12005)
4/27/2008 12:44:05 AM
On 27 Apr, 02:44, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> It worked for me.
>
> I don't have another suggestion--except for you to try it again.
>
> You could explain where each range is--is the table on sheet1 or the sheet=
 with
> the formula?
>
> And please copy|paste the formula you're using from the formula bar. =A0Do=
n't type
> it into the message. =A0Too many things can go wrong.
>
>
>
>
>
> Oslopelle wrote:
>
> > On 26 Apr, 16:04, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > > Try wrapping the =3Dvlookup() with =3Dindirect(vlookup())
>
> > > =3DSumif($A$7:$A$1447;"<"&X3;indirect(vlookup(e3;AT3:AU11;2;false)))
> > > -Sumif($A$7:$A$1447;"<"&y3;indirect(vlookup(e3;AT3:AU11;2;false)))
>
> > > (aren't you missing some ()'s in your posted formula?
>
> > > Oslopelle wrote:
>
> > > > I am trying to use a lookup-function to determine a different sum
> > > > range for several criteria.
> > > > Like so:
> > > > =3DSumif($A$7:$A$1447;"<"&X3;vlookup(e3;AT3:AU11;2;false)-Sumif($A$7=
:$A
> > > > $1447;"<"&y3;vlookup(e3;AT3:AU11;2;false)
> > > > The problem is that the vlookup returns text and not the cell
> > > > reference. Is there a way to get the answer from the lookup expresse=
d
> > > > as cell reference instead of text, since sumif can't use text, just
> > > > the cell reference?
>
> > > > I use it to calculate the number of hours the staff should be paid, =
so
> > > > it's different from weekdays to saturdays, holidays and sundays
> > > > in at3 to at11 i have the days (1 for sunday) of the week and in au3=

> > > > to au11 i have the ranges for the reference table with pay per minut=
e.
> > > > 1 =A0 =A0 =A0 sheet1!$E$7:$E$1447
> > > > 2 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 3 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 4 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 5 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 6 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 7 =A0 =A0 =A0 sheet1!$D$7:$D$1447
> > > > holliday =A0 =A0 =A0 =A0sheet1!$F$7:$F$1447
> > > > eve =A0 =A0 sheet1!$G$7:$G$1447
>
> > > > /Oslopelle
>
> > > --
>
> > > Dave Peterson- D=F6lj citerad text -
>
> > > - Visa citerad text -
>
> > unfortunatley i ony get an error message when trying to make an
> > indirect function. In swedish it comes out as ber=E4kningsbar -
> > calculable an the sumif won't accept that as a cell reference in the
> > sum range.
> > I now have:
> > Sumif(sheet1!$A$7:$A$1447;"<"&X3;vlookup(e3;sheet1!AT3:AU11;2;false))-
> > sumif(sheet1!$A$7:$A$1447;"<"&Y3;vlookup(e3;sheet1!AT3:AU11;2;false))
>
> > if e3=3D 4
> > the lookup would return the answer "sheet1!$c$7:$c$1447"
>
> > AT =A0 =A0 =A0 =A0 =A0 =A0AU
> > > > 1 =A0 =A0 =A0 =A0 sheet1!$E$7:$E$1447
> > > > 2 =A0 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 3 =A0 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 4 =A0 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 5 =A0 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 6 =A0 =A0 =A0 =A0 sheet1!$C$7:$C$1447
> > > > 7 =A0 =A0 =A0 =A0 sheet1!$D$7:$D$1447
> > > > holliday =A0sheet1!$F$7:$F$1447
> > > > eve =A0 =A0 =A0 sheet1!$G$7:$G$1447
>
> > the problem is that the sumif does not recognize that result as a cell
> > reference. it thinks it is text and the sumif returns an error.How do
> > i change this? it only needs to recognize the result as a range.
>
> > a contains a day in minutes, x is the beginning time of the empployee,
> > y is the ending time of the employee, c,d, e, f, g are the respective
> > compensation the emplyee gets for working that minute (double time=3D2,
> > 150% =3D1,5, 133%=3D1,33 or normal time=3D1).
>
> > a is the day, 1 for sunday, 2 for monday and so on, au is a written
> > cell reference.
>
> --
>
> Dave Peterson- D=F6lj citerad text -
>
> - Visa citerad text -

It does work, it was just me and bad syntax!!
Thanks a million for the help! It sure made my day!!
/Oslopelle
0
oslopelle (6)
4/27/2008 5:40:23 AM
Reply:

Similar Artilces:

How can I translate a comment to text in a cell?
A cell has existing text in it and it has a comment attached to it. I'd like to append the comment to the end to the existing text in the cell. Has anyone done this already? Is it possible without going into each and every comment? Thanks, Chris ASAP utilities has a UDF formula called "ASAPGetComment()". If you install this utility (which I highly and impartially recomend), you could use this formula to concatenate the two together. http://www.asap-utilities.com "DFIChris" wrote: > A cell has existing text in it and it has a comment attached to it. I...

reformat text in a cell
I have 2000+ cells that look like this: UK00001 Geddy Lee 2112 Bytor Ln GLENVIEW, IL 60025-1522 Is there a simple way to add a space after each line? right now when i paste it into a word doc, it shows like this : UK00001 Geddy Lee2112 Bytor LnGLENVIEW, IL 60025-1522 I would like to REFORMAT every cell to look like this with spaces in between to make it readable: UK00001 Geddy Lee 2112 Bytor Ln GLENVIEW, IL 60025-1522 any suggestions? ...

Outlook/HTML/Text only problem.
I reformatted my TOSHIBA M35X Satellite (laptop) with XP Home SP2 last month, and now only MY e-mail account, http, (1 of 4 [2 http and 2 pop3]) opens all mail as text with an option to Read as html. The other 3 accounts do not have this problem. Either way, no links work in the message display UNLESS they are daily deliveries from MSN Groups or their ads. Outlook 2003 SP2 (Standard Edition.) What the h**l is wrong? Is this a new problem with Microsoft Office 2003? Are the items in the Junk E-mail folder? "Kelly J" <bikers46@msn.com> wrote in message news:eqL3PvM$FH...

Excel radial diagram text offset
I have a radial diagram. In this diagram the value arrays are displayed in relation to there total sum. The values of the arrays are displayed as absolute number not in percent of the total sum. How can I get the total sum of all the arrays to be displaed in the diagram without to be forced to calculate it separately? A chart does no calculations for you. If you want a value in the chart, you must calculate it, and point the chart at the calculation. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _...

Outlook 2003 sending blank emails / text missing from body
Hi I have just upgraded three machines to office 2003, outlook works fine on two machines but the third has the blank email body problem on all sent mails. Has anyone come up with a solution to this:- Every time I send a mail the recipient receives a blank mail, even the mail within the sent items is blank. I have tried changing the mail setting etc but as yet no solution. The set up on the machine is identical to the other two machines; the only difference is that this machine had an existing Outlook 2002 account set up that was imported when 2003 was installed. Therefore it had an existi...

Vertical text, font corruption #3
Hi there. I'm trying to draw a vertical text. But I see the font is corrupted. I mean it looks ugly. No antialiasing and so. whe I draw the text horizontal it looks just fine. I'm using "lf.lfEscapement = - 90 * 10;" to make a font vertical and "pDC->TextOut(20, 22, sTitle);" for drawing. lf.lfQuality = ANTIALIASED_QUALITY for both vertical and horizontal. Have now idea what it could be... Any ideas? Thanks. ...

how to append text to the end of a row
I have to batch rename a few thousand images that are named something like 1-1234-1111-1.jpg A program I have can rename using a csv file with 2 columns originalname;newname 1-1234-1111-1.jpg;978-1-1234-1111-1.jpg This works awesome, however it has to include the extension because otherwise it can't match up the files... which is good because its possible that there could be files with the same name but different extension. I can easily open the csv in notepad and find replace ; with .jpg; but I don't know how to do that for the 2nd row. There is a space after the last characte...

Status bar text size
Using Office 2002 with Windows XP. OK, I give up. I need to increase the font size in the Status Bar display, the part that displays Ready as well as the Sum of a column of selected numbers. I thought it was a general Windows setting under the Advanced button, but I couldn't find which one. I'm using the Windows Classic Style, Windows Standard, Font Size Large (Extra large makes everything else too large and it doesn't seem to affect the Status bar text anyway). making the Sheetname font larger would be helpful as well. Probably the same setting but I can't find it. -- Fred...

Text box is displayed when cell is activated
I have a spreadsheet that was created by someone else. When you activate specific cells, what appears to be a text box appears with specific information (e.g., Enter a 4 digit branch number here") about what is required in this column. I would like to remove these but I cannot find how they are linked to the specific cell. The cell contents are displayed in the menu bar (Branch). Can anyone help? ...

How do I clear blank space at the top of a word-wrapped text cell?
Often when I set cells to word-wrap and then auto-fit the row height, cells with text will end up with a blank line or two at the top. It's not extra spaces in the text because when I go to the formula bar, there's nothing before the start of the text. I can manually adjust the size of each row, but that's a hassle and not very consistent! Thanks. In the same Format, Cells, Alignment, select Top in Text Alignment Vertical. HTH, Carole O "mirage1210" wrote: > Often when I set cells to word-wrap and then auto-fit the row height, cells > with text will ...

curving text in Word for Mac
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I would like to know how to curve text in Word for Mac in the way WordArt lets you do that in Mac for PCs. Thanks. Que? That question came out very jumbled :-) I think you're looking for "Fit text to path", a feature which is not provided in current versions of Mac Word. The closest you will come is Word Art. Look in the Elements Gallery for WordArt. Cheers On 18/02/10 7:14 AM, in article 59bb30b8.-1@webcrossing.JaKIaxP2ac0, "Edward_Schuldt@officeformac.com" <Edward_Schuldt@officef...

Formating Text in a List Box
How do I increase or format the text in a list box? Thanks! In the Properties Box you can set the Font, Style and Size. PC "PSTEWART" <PSTEWART@discussions.microsoft.com> wrote in message news:C26CF8F6-8C68-4809-9F49-54041CCCE9B1@microsoft.com... > How do I increase or format the text in a list box? Thanks! Thanks for your post. When I create a "list box" from the Forms toolbar, the properties box does not have any options to change the font size. I am assuming that the text size is set to the default text (font and size) of the workkbook.. "PC&...

How do I convert Organizer 6.0 file to text file for import to Outlook
Many people have said to just export an organizer file as a text file, then import to Outlook. I can't even get past that step. I am using Organizer 6.0 and Outlook 2002. When I open Organizer and go to Export, there is not even a file available to export. The only file I am aware of is an .OR6 file, but that is not one of the options on the export function. Any help? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ...

one more text box to a userform
XL2000 I am adding one more text box to a userform to put information in column "BT" ROW "2" in "sheet1" the below code works perfectly so I figured if I installed a new text box and named it "Textwrknmbr" then all I would have to do is add a few lines in the code. i tried and failed please guide me from here down works perfectly Private Sub cmdAdd_Click() Dim r As Long Dim ws As Worksheet Set ws = Worksheets("Parts") With ws If .AutoFilterMode Then If .FilterMode Then .ShowAllData End If End If End With If Applic...

Why do my text boxes disappear from my chart when I click out?
I have manually added text boxes in the chart to label my data points with words. When I click out of the chart, some of them appear on the worksheet behind the chart, and some stay in the chart. I can't figure out why some are there and some aren't. When I am in the chart, they all appear on the chart. I am in Microsoft Office 2000 using Excel and Word. Also, when I go to copy and paste the chart into word, the text doesn't go with it. Instead of inserting a text box, select the chart, and start typing. You'll see the text in the formula bar as you type. Press the...

XML , text, from xmlwriter.
Is there a simple way to get the text, xml, from an xmlwriter. I have a XML writer that writes to a file, and I want another function to return the text that the xml writer is produced. Any suggestions? MAF wrote: > Is there a simple way to get the text, xml, from an xmlwriter. > > I have a XML writer that writes to a file, and I want another function to > return the text that the xml writer is produced. Use an XmlWriter over a StringWriter e.g. StringWriter stringWriter = new StringWriter(); using (XmlWriter xmlWriter = XmlWriter.Create(stringWriter)) { xmlWrit...

OWA appears in a TEXT almost an FTP looking.
G'day all, I have got Win2k3 plus Ex2k3 with SP1 installed. Email internally is fine but the OWA looks terrible, it appears in a text format rather than the funky looking OWA. I dont know what I am doing wrong , I really need some guidance here. I've tried almost all hotfixes, should i do the compression ? Regards eyetea On Sun, 23 Jan 2005 15:57:01 -0800, eyetea <eyetea@discussions.microsoft.com> wrote: >G'day all, > >I have got Win2k3 plus Ex2k3 with SP1 installed. >Email internally is fine but the OWA looks terrible, it appears in a text >format rath...

Why is copy/paste not copying the correct text?
Microsoft Publisher 2003: Occasionally when I copy something from one document, something different appears in my publisher text box when I paste. It's usually something recently pasted. How do I fix this? ...

How do I stop Excel auto formatting the text 3-4 as 04 Apr?
I run a web query that imports soccer results to Excel. Unfortunately the web site formats the result as 3-1 for example. This text is automatically converted to 03 Jan by Excel. I can't seem to stop this happening, even if I explicitly set the cell format to text. Doing so just converts the contents, which were a date, to the internal date number and if I re load the data it reverts to 03 Jan again. Does anyone know how I might get excel to leave the format of the cells alone? thanks ahughf There is no turn off for this, you can either preformat the cells as text or precede the e...

why does some text disappear in Web publication from Publisher?
When I convert a Publisher document to Web then do a Web preview, some text is missing. ...

Text box based on form entry
I have a form with a subform. I want the form to display a label or text box that says "Deleted" if my delete checkbox is checked on the subform. I also want the same label or text box to appear on a report that refers to the same record. Any thoughts would be most helpful TIA Papa Papa Jonah wrote: >I have a form with a subform. >I want the form to display a label or text box that says "Deleted" if my >delete checkbox is checked on the subform. >I also want the same label or text box to appear on a report that refers to >the same record. Try setting...

Handling return key in text input field
I'm developing a dialog-based MFC application. It has a couple of text input fields. I've discovered that if I press return in either of these fields, the application exits. For now, I've worked round it by setting the multiline property, but I don't really want multiline fields. I just want to ignore the return key. How can I do this please? You can override OnOK and refrain from calling the base class. In VC++ 7.1 or higher, you could add a command handler for IDOK and refrain from calling CDialog::OnOk from that. -- Regards, Nish [VC++ MVP] "News" &...

Text Box with words splitting onto two lines
I have a text box in publisher with a lots of text but it splits up words onto two lines Eg It is a very sun- ny day today is there a way to stop it so it puting words on 2 lines Thanks S.Dickson@shos.co.uk wrote: > is there a way to stop it so it puting words on 2 lines For the current text box: Tools > Language > Hyphenation For all new text boxes: Tools > Options -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org ...

Modifying SmartArt Text through Object Model
Does anyone know if it is possible to modify the text within a SmartArt object through the use of the Office object model? JD3K wrote: > Does anyone know if it is possible to modify the text within a > SmartArt object through the use of the Office object model? No, it isn't possible. That part of the object model is read-only. You can read the text from an inline object (modifying the index numbers as necessary) with ActiveDocument.InlineShapes(1).GroupItems(1).TextFrame2.TextRange.Text but trying to assign a string to that property fails. Also, I get various b...

How do I change REPLY font to smaller size and FORCE Plain Text to be used ALWAYS?
Read, compose fonts are now smaller size. :) The splash screen is NOW a smaller font size and also the list of folders and inbox emails are in smaller font. :) BUT when I go to reply to an email, the font is huge, and the copy of the message I am replying to at the bottom of the reply screen is also in huge font. How do I get those smaller font size? Plus, I have OE set to read ALL mail in plain text. So, why, when I go to reply to an email that was read in plain text, does the reply revert to HTML? Yes, I can change it to plain text, but that is not the point. I read in ...