Formating Issues

I have a Publisher 2003 Brochure in progress.  I only need the first page of 
this two page document.  I can find no way to save only the first page of 
this work.  Additionally, I've inserted a text box for a list of items and 
want to divide it into two columns.  Need some guidance on how this would be 
done.  Much thanks for any assistance.
0
Maurice (43)
5/8/2009 1:34:02 AM
publisher 21446 articles. 6 followers. Follow

8 Replies
525 Views

Similar Articles

[PageSpeed] 20

Go to page two, Edit, delete page. Save with a new name if you want both files.

Right-click the text box, click format text box, Text Box tab, columns button.

-- 
Mary Sauer
http://msauer.mvps.org/

"Maurice" <Maurice@discussions.microsoft.com> wrote in message 
news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
>I have a Publisher 2003 Brochure in progress.  I only need the first page of
> this two page document.  I can find no way to save only the first page of
> this work.  Additionally, I've inserted a text box for a list of items and
> want to divide it into two columns.  Need some guidance on how this would be
> done.  Much thanks for any assistance. 


0
mary.sauer (2018)
5/8/2009 10:01:01 AM
Much thanks tor the timely reply.  Regrettably, When on the second page, the 
edit option does not offer a 'delete page'  even when the double caret 
exposes all of the drop down options.  Additionally, I have tried removing 
all of the text boxes and type of the second page only to find that that it 
remains.  

"Mary Sauer" wrote:

> Go to page two, Edit, delete page. Save with a new name if you want both files.
> 
> Right-click the text box, click format text box, Text Box tab, columns button.
> 
> -- 
> Mary Sauer
> http://msauer.mvps.org/
> 
> "Maurice" <Maurice@discussions.microsoft.com> wrote in message 
> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
> >I have a Publisher 2003 Brochure in progress.  I only need the first page of
> > this two page document.  I can find no way to save only the first page of
> > this work.  Additionally, I've inserted a text box for a list of items and
> > want to divide it into two columns.  Need some guidance on how this would be
> > done.  Much thanks for any assistance. 
> 
> 
> 
0
Maurice (43)
5/8/2009 12:48:08 PM
Do you see Page tabs down on the status bar? If so, right click on the page 
2 tab and delete.

-- 
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression






"Maurice" <Maurice@discussions.microsoft.com> wrote in message 
news:2F8CC066-9C5E-4261-B2E7-A5C1E78DCA95@microsoft.com...
> Much thanks tor the timely reply.  Regrettably, When on the second page, 
> the
> edit option does not offer a 'delete page'  even when the double caret
> exposes all of the drop down options.  Additionally, I have tried removing
> all of the text boxes and type of the second page only to find that that 
> it
> remains.
>
> "Mary Sauer" wrote:
>
>> Go to page two, Edit, delete page. Save with a new name if you want both 
>> files.
>>
>> Right-click the text box, click format text box, Text Box tab, columns 
>> button.
>>
>> -- 
>> Mary Sauer
>> http://msauer.mvps.org/
>>
>> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
>> >I have a Publisher 2003 Brochure in progress.  I only need the first 
>> >page of
>> > this two page document.  I can find no way to save only the first page 
>> > of
>> > this work.  Additionally, I've inserted a text box for a list of items 
>> > and
>> > want to divide it into two columns.  Need some guidance on how this 
>> > would be
>> > done.  Much thanks for any assistance.
>>
>>
>> 

0
webmaster911 (1600)
5/8/2009 2:01:38 PM
Where did you get the brochure template? I cannot understand not being able to 
delete the second page? Did Rob's solution work? You can copy the brochure and 
paste to a new instance of Publisher. Make note of the color scheme, many times 
it will change when you paste.
-- 
Mary Sauer
http://msauer.mvps.org/

"Maurice" <Maurice@discussions.microsoft.com> wrote in message 
news:2F8CC066-9C5E-4261-B2E7-A5C1E78DCA95@microsoft.com...
> Much thanks tor the timely reply.  Regrettably, When on the second page, the
> edit option does not offer a 'delete page'  even when the double caret
> exposes all of the drop down options.  Additionally, I have tried removing
> all of the text boxes and type of the second page only to find that that it
> remains.
>
> "Mary Sauer" wrote:
>
>> Go to page two, Edit, delete page. Save with a new name if you want both 
>> files.
>>
>> Right-click the text box, click format text box, Text Box tab, columns 
>> button.
>>
>> -- 
>> Mary Sauer
>> http://msauer.mvps.org/
>>
>> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
>> >I have a Publisher 2003 Brochure in progress.  I only need the first page of
>> > this two page document.  I can find no way to save only the first page of
>> > this work.  Additionally, I've inserted a text box for a list of items and
>> > want to divide it into two columns.  Need some guidance on how this would 
>> > be
>> > done.  Much thanks for any assistance.
>>
>>
>> 


0
mary.sauer (2018)
5/8/2009 2:23:10 PM
All:

    Just realized a gross error on my part for which an apology is owed to 
all who contributed to the solution of this issue.  This was a project that 
originated in Publisher 2003.  I either copied the elements into word or 
found the same publication in word.   I would ask, however, if the same 
suggested solutions would work for the word document.  Your valuable advice 
is still sought

"Mary Sauer" wrote:

> Where did you get the brochure template? I cannot understand not being able to 
> delete the second page? Did Rob's solution work? You can copy the brochure and 
> paste to a new instance of Publisher. Make note of the color scheme, many times 
> it will change when you paste.
> -- 
> Mary Sauer
> http://msauer.mvps.org/
> 
> "Maurice" <Maurice@discussions.microsoft.com> wrote in message 
> news:2F8CC066-9C5E-4261-B2E7-A5C1E78DCA95@microsoft.com...
> > Much thanks tor the timely reply.  Regrettably, When on the second page, the
> > edit option does not offer a 'delete page'  even when the double caret
> > exposes all of the drop down options.  Additionally, I have tried removing
> > all of the text boxes and type of the second page only to find that that it
> > remains.
> >
> > "Mary Sauer" wrote:
> >
> >> Go to page two, Edit, delete page. Save with a new name if you want both 
> >> files.
> >>
> >> Right-click the text box, click format text box, Text Box tab, columns 
> >> button.
> >>
> >> -- 
> >> Mary Sauer
> >> http://msauer.mvps.org/
> >>
> >> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
> >> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
> >> >I have a Publisher 2003 Brochure in progress.  I only need the first page of
> >> > this two page document.  I can find no way to save only the first page of
> >> > this work.  Additionally, I've inserted a text box for a list of items and
> >> > want to divide it into two columns.  Need some guidance on how this would 
> >> > be
> >> > done.  Much thanks for any assistance.
> >>
> >>
> >> 
> 
> 
> 
0
Maurice (43)
5/8/2009 2:34:02 PM
When you fill a page with text or graphics, Microsoft Office Word inserts an 
automatic page break and starts a new page. However, you can manually add pages 
or delete pages by adding page breaks or deleting page breaks. You can also add 
a cover page at the beginning of your document.


-- 
Mary Sauer
http://msauer.mvps.org/

"Maurice" <Maurice@discussions.microsoft.com> wrote in message 
news:C4760938-C4DE-4AAA-9601-C23124774181@microsoft.com...
> All:
>
>    Just realized a gross error on my part for which an apology is owed to
> all who contributed to the solution of this issue.  This was a project that
> originated in Publisher 2003.  I either copied the elements into word or
> found the same publication in word.   I would ask, however, if the same
> suggested solutions would work for the word document.  Your valuable advice
> is still sought
>
> "Mary Sauer" wrote:
>
>> Where did you get the brochure template? I cannot understand not being able 
>> to
>> delete the second page? Did Rob's solution work? You can copy the brochure 
>> and
>> paste to a new instance of Publisher. Make note of the color scheme, many 
>> times
>> it will change when you paste.
>> -- 
>> Mary Sauer
>> http://msauer.mvps.org/
>>
>> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> news:2F8CC066-9C5E-4261-B2E7-A5C1E78DCA95@microsoft.com...
>> > Much thanks tor the timely reply.  Regrettably, When on the second page, 
>> > the
>> > edit option does not offer a 'delete page'  even when the double caret
>> > exposes all of the drop down options.  Additionally, I have tried removing
>> > all of the text boxes and type of the second page only to find that that it
>> > remains.
>> >
>> > "Mary Sauer" wrote:
>> >
>> >> Go to page two, Edit, delete page. Save with a new name if you want both
>> >> files.
>> >>
>> >> Right-click the text box, click format text box, Text Box tab, columns
>> >> button.
>> >>
>> >> -- 
>> >> Mary Sauer
>> >> http://msauer.mvps.org/
>> >>
>> >> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> >> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
>> >> >I have a Publisher 2003 Brochure in progress.  I only need the first page 
>> >> >of
>> >> > this two page document.  I can find no way to save only the first page 
>> >> > of
>> >> > this work.  Additionally, I've inserted a text box for a list of items 
>> >> > and
>> >> > want to divide it into two columns.  Need some guidance on how this 
>> >> > would
>> >> > be
>> >> > done.  Much thanks for any assistance.
>> >>
>> >>
>> >>
>>
>>
>> 


0
mary.sauer (2018)
5/8/2009 4:01:44 PM
The recommendation to insert a page break did remove the text and graphics 
from the document. The second page, however, still exists.  I have reviewed 
every option in the 'edit' selection in the toolbar.  The list is:

-undo cut
-repeat cut
-cut
-copy
-Office Clipboard
-Paste
-Paste Special
-Paste as Hyperlink
-Clear
-Select All
-Find
-Replace
-Go to
-Reconvert
-Links
-Object

 I fully respect the collective wisdom of all who have shared their 
knowledge but I simply cannot find 'delete page' on edit or any other portion 
of the toolbar.  The cursor can be placed at the upper left corner of the 
newly blank page but holding the delete key does not remove page two. I have 
also tried to drag the mouse over the contents of page one so to paste it 
into a new word document. 




"Mary Sauer" wrote:

> When you fill a page with text or graphics, Microsoft Office Word inserts an 
> automatic page break and starts a new page. However, you can manually add pages 
> or delete pages by adding page breaks or deleting page breaks. You can also add 
> a cover page at the beginning of your document.
> 
> 
> -- 
> Mary Sauer
> http://msauer.mvps.org/
> 
> "Maurice" <Maurice@discussions.microsoft.com> wrote in message 
> news:C4760938-C4DE-4AAA-9601-C23124774181@microsoft.com...
> > All:
> >
> >    Just realized a gross error on my part for which an apology is owed to
> > all who contributed to the solution of this issue.  This was a project that
> > originated in Publisher 2003.  I either copied the elements into word or
> > found the same publication in word.   I would ask, however, if the same
> > suggested solutions would work for the word document.  Your valuable advice
> > is still sought
> >
> > "Mary Sauer" wrote:
> >
> >> Where did you get the brochure template? I cannot understand not being able 
> >> to
> >> delete the second page? Did Rob's solution work? You can copy the brochure 
> >> and
> >> paste to a new instance of Publisher. Make note of the color scheme, many 
> >> times
> >> it will change when you paste.
> >> -- 
> >> Mary Sauer
> >> http://msauer.mvps.org/
> >>
> >> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
> >> news:2F8CC066-9C5E-4261-B2E7-A5C1E78DCA95@microsoft.com...
> >> > Much thanks tor the timely reply.  Regrettably, When on the second page, 
> >> > the
> >> > edit option does not offer a 'delete page'  even when the double caret
> >> > exposes all of the drop down options.  Additionally, I have tried removing
> >> > all of the text boxes and type of the second page only to find that that it
> >> > remains.
> >> >
> >> > "Mary Sauer" wrote:
> >> >
> >> >> Go to page two, Edit, delete page. Save with a new name if you want both
> >> >> files.
> >> >>
> >> >> Right-click the text box, click format text box, Text Box tab, columns
> >> >> button.
> >> >>
> >> >> -- 
> >> >> Mary Sauer
> >> >> http://msauer.mvps.org/
> >> >>
> >> >> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
> >> >> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
> >> >> >I have a Publisher 2003 Brochure in progress.  I only need the first page 
> >> >> >of
> >> >> > this two page document.  I can find no way to save only the first page 
> >> >> > of
> >> >> > this work.  Additionally, I've inserted a text box for a list of items 
> >> >> > and
> >> >> > want to divide it into two columns.  Need some guidance on how this 
> >> >> > would
> >> >> > be
> >> >> > done.  Much thanks for any assistance.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
> 
0
Maurice (43)
5/8/2009 5:31:02 PM
Go to a Word forum, they will be happy to help
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.word.docmanagement&cat=en_US_ce704816-2055-4ee8-a8f1-2496ab2e29d3&lang=en&cr=US

-- 
Mary Sauer
http://msauer.mvps.org/

"Maurice" <Maurice@discussions.microsoft.com> wrote in message 
news:0EC88E3F-10C6-4390-8C46-72417E3F85E6@microsoft.com...
> The recommendation to insert a page break did remove the text and graphics
> from the document. The second page, however, still exists.  I have reviewed
> every option in the 'edit' selection in the toolbar.  The list is:
>
> -undo cut
> -repeat cut
> -cut
> -copy
> -Office Clipboard
> -Paste
> -Paste Special
> -Paste as Hyperlink
> -Clear
> -Select All
> -Find
> -Replace
> -Go to
> -Reconvert
> -Links
> -Object
>
> I fully respect the collective wisdom of all who have shared their
> knowledge but I simply cannot find 'delete page' on edit or any other portion
> of the toolbar.  The cursor can be placed at the upper left corner of the
> newly blank page but holding the delete key does not remove page two. I have
> also tried to drag the mouse over the contents of page one so to paste it
> into a new word document.
>
>
>
>
> "Mary Sauer" wrote:
>
>> When you fill a page with text or graphics, Microsoft Office Word inserts an
>> automatic page break and starts a new page. However, you can manually add 
>> pages
>> or delete pages by adding page breaks or deleting page breaks. You can also 
>> add
>> a cover page at the beginning of your document.
>>
>>
>> -- 
>> Mary Sauer
>> http://msauer.mvps.org/
>>
>> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> news:C4760938-C4DE-4AAA-9601-C23124774181@microsoft.com...
>> > All:
>> >
>> >    Just realized a gross error on my part for which an apology is owed to
>> > all who contributed to the solution of this issue.  This was a project that
>> > originated in Publisher 2003.  I either copied the elements into word or
>> > found the same publication in word.   I would ask, however, if the same
>> > suggested solutions would work for the word document.  Your valuable advice
>> > is still sought
>> >
>> > "Mary Sauer" wrote:
>> >
>> >> Where did you get the brochure template? I cannot understand not being 
>> >> able
>> >> to
>> >> delete the second page? Did Rob's solution work? You can copy the brochure
>> >> and
>> >> paste to a new instance of Publisher. Make note of the color scheme, many
>> >> times
>> >> it will change when you paste.
>> >> -- 
>> >> Mary Sauer
>> >> http://msauer.mvps.org/
>> >>
>> >> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> >> news:2F8CC066-9C5E-4261-B2E7-A5C1E78DCA95@microsoft.com...
>> >> > Much thanks tor the timely reply.  Regrettably, When on the second page,
>> >> > the
>> >> > edit option does not offer a 'delete page'  even when the double caret
>> >> > exposes all of the drop down options.  Additionally, I have tried 
>> >> > removing
>> >> > all of the text boxes and type of the second page only to find that that 
>> >> > it
>> >> > remains.
>> >> >
>> >> > "Mary Sauer" wrote:
>> >> >
>> >> >> Go to page two, Edit, delete page. Save with a new name if you want 
>> >> >> both
>> >> >> files.
>> >> >>
>> >> >> Right-click the text box, click format text box, Text Box tab, columns
>> >> >> button.
>> >> >>
>> >> >> -- 
>> >> >> Mary Sauer
>> >> >> http://msauer.mvps.org/
>> >> >>
>> >> >> "Maurice" <Maurice@discussions.microsoft.com> wrote in message
>> >> >> news:B4F38788-8D36-4822-A5A0-4D54AE7634EE@microsoft.com...
>> >> >> >I have a Publisher 2003 Brochure in progress.  I only need the first 
>> >> >> >page
>> >> >> >of
>> >> >> > this two page document.  I can find no way to save only the first 
>> >> >> > page
>> >> >> > of
>> >> >> > this work.  Additionally, I've inserted a text box for a list of 
>> >> >> > items
>> >> >> > and
>> >> >> > want to divide it into two columns.  Need some guidance on how this
>> >> >> > would
>> >> >> > be
>> >> >> > done.  Much thanks for any assistance.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>> 


0
mary.sauer (2018)
5/8/2009 5:50:57 PM
Reply:

Similar Artilces:

Custom formatting #7
How can I do the following custom formatting – I need trailing dots before the number ……..1,234.00 Thanks for any help Right Click > Format Cells > Select Custom Enter "........ "0.00 "John Knoke" <JohnKnoke@discussions.microsoft.com> wrote in message news:586761E6-32A9-4911-BF50-3790614145B2@microsoft.com... > > How can I do the following custom formatting - > I need trailing dots before the number > ....1,234.00 > > Thanks for any help > > John, Use a custom number format of *.#,###.00 Note the period between the * and the f...

Convert time stored as decimalised number to time format
Hello How can I convert 3.5 hours to 3:30:00? -- Emma Emma A1/24 and formate as time Mike Rogers "Emma" wrote: > Hello > How can I convert 3.5 hours to 3:30:00? > -- > Emma ...

Printing Issues when distributing a form to multiple users
I am distributing a spreadsheet to multiple users. The spreadsheet is being used as a form for data entry. The problem i am having is that when it is being printed, the users are getting varying page layouts where the page breaks have changed, due the changes to the length of the document growing from the free text they are entering. The page breaks that excel chooses don't seem to be spaced well, leading to one or two of the pages being very short (i.e., leaving a lot of free white space), whereas the other pages are taking up the entire page. Is there a particular page layout selection...

Keeping the format but update the data
I have a report I run everyday. I want to update the data, but keep the column sizes and formatting. Any suggestions? Anybody suggest a good ebook to become more formuliar with excel? JoeM JoeM, this could be as simple as recording a macro during the formatting of the sheet after importing the data once. Then each day, after importing the new data, you simply run that macro. As for online eBook's for Excel, I'm not actually aware of any although I suspect a Google search would turn up several. It's hard to beat the "For Dummies..." series of hardcopy...

NEED HELP-wrong formatting saved ??
After using word 2007 and saving a word file, it changed the formatting from the previous file (i think it was .wps microsoft works word processor) and now its all messed up.....I think I saved it in some other wrong encoding standard......now, whenever I open this file now half of it is in some weird looking unreadable characters....like this with wha捬屨捦ㅳ尠晡‰汜牴档晜獣‰歜牥楮杮尰扤档慜㍦㔱㔰楜獮獲摩㌱ㄳ〶‷਍灜牡素筽⩜灜獮捥癬ㅬ灜畮牣屭湰瑳牡ㅴ灜楮摮湥㝴〲灜桮湡⁧屻湰硴慴ges! That is what seems to happen once the system breaks its laws from the inside. ......couldnt find online solutions...does anyone have any suggestions or s...

Conditional Formating: linking to display another cell
Hello, I am trying to make a traffic light with symbols and I've read to 'use a separate cell for the dropdown choices, with their resulting value linked into the formatted cell through an IF function, using the character that you want to display.' So: =IF someone enters '1' in B8, THEN display contents of $C$4 (will it display font and attributes?) =IF someone enters '2' in B8, THEN display contents of $C$5 =IF someone enters '3' in B8, THEN display contents of $C$6 But I've been reading everywhere and CF is very new to me and I need ...

Issue when using Outlook 2003 on Exchange 5.5 SP4
Hi! I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can anyone guide me on how to handle this? M P What issues have you seen? -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "M P" <mark@textguru.ph> wrote in message news:eoqSaBjTGHA.5884@TK2MSFTNGP14.phx.gbl... > Hi! > > I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can > anyone guide me on how to handle this? > > M P > It was pretty easy for me to find this in the Microsoft Knowledge Base: http://support.microsoft...

Newbie Needs Help With Formatting E-Mails
Newbie Needs Help With Formatting E-Mails Hi all. I'm new to this site and would appreciate some formatting help. I created a new Word doc and copied and pasted some graphics and some simple text boxes in to it. The graphics and text boxes were created in Powerpoint by someone else. Looks fine on my screen. Before sending it out via e-mail to an Outlook e-mail group I have, I first sent myself a test message to see what it would look like on the receiving end. It looks a mess! The text boxes are all over the place, as is the text that is not in a box. Also, everything slide over to ...

2003 format in 2007?
I'm used to Outlook 2003, but I just bought a new computer and installed Outlook 2007. I view a week at a time, and I prefer the calendar format in 2003 -- it shows the whole week in two columns and I didn't have to scroll. Is there a way I can use the same format in 2007? No, unfortunately that view had to be removed to enabled calendar overlay. Try a two week view: http://slipstick.me/2wk -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dai...

formatting #2
Is the strikethrough formatting option no longer available in Publisher? Or if you need to use a strikethrough do you have to draw a line through the text? The line does not always stay in the same spot when you group and then have to paste on another page. Waggie wrote: > Is the strikethrough formatting option no longer available in > Publisher? Or if you need to use a strikethrough do you have to draw > a line through the text? The line does not always stay in the same > spot when you group and then have to paste on another page. ========================== You have the an...

Trying to get a type of video file format to open and run on my we
I created a video using Windows Movie maker and saved as .wmp file. I saved it to my computer and then inserted on my web page under Front Page 2003. Nothing! I then converted the file to avi format - still nothing! I then tried mpeg4 still nothing. The manual is next to useless on this subject. Anyone tell me what I need to do so that when a user opens up the page the video plays automatically. -- Simon Holloway Save as a .wmv and insert a suitable player into the page. For IE only, Insert->Web Component->Advanced Controls->ActiveX Control Click Next Choose Window...

Text formatted email
I am trying to email a long hyperlink path to some one that can only receive text formatted emails. When they receive the email it, the hyperlink gets converted in to 2 lines, top line is a hyperlink (path incomplete) the second line is "text" with the balance of the hyperlink path. I placed < > around the hyperlink and it still splits in to 2 lines. Is there any way to keep the full link path intact? Thanks! jvs Tiny URL to the rescue! :-) http://tinyurl.com/ -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Cr...

Import data not in correct format
Import data reads: Need to do statistical anaysis on hundreds of numbers and Cell value # of Cells don't want to enter the numbers by hand. 3 1 4 2 Would like: Cell Value 3 4 4 ...

Four Conditional Formats?
Dear all, I am attempting to set up a template for someone else to use on another machine, and wish conditional format a cell such that it has four potential formats. The first is based on an adjacent cell value, and if this is met, then it is colour 1. The remaining three, are all AND statements involving the first cell and another cell value being less than date A, less than date B or less than date C. Is this possible to do? I have limited VB knowledge, and am wary of using add-ins as the people I am sending this to to use have limited excel knowledge. Regards, Steve -- stevepain -...

Conditional Format
Hi, I want to assign a number to a certain conditional format. When the condition is true it should put a 1 in the cell and when the condition is false a zero or nothing should be assigned. Anyone? I seem to make the wrong code all the time. Thanks, Johanna Use the same test that the CF uses, and return 1 for TRUE and "" for FALSE. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jootje" <Jootje@discussions.microsoft.com> wrote in message news:CB0B3201-2DD9-466A-94FF-108691C77FAF@microsoft.com... > Hi, > >...

my formats get pushed out when I insert columns
Hi folks, I am having trouble when inserting columns in a large data field. Whenever I insert a column at some point in the data field, th formulas within the data field adjust, or 'stretch', to accomodate th added column, however my conditional formatting gets pushed along t the right and doesn't adapt itself in the same way the formulas do. This means whenever I insert a column, the formulas remain correct bu I have to reset the conditional formatting for the entire data field. I would be extremely grateful for any advice on this situation. Best regards, melvi -- Message pos...

OL2000/MAPISP32 issue
This one has me baffled. I think it might have to do with the AVG antivirus software I recently installed, with which I am generally perfectly happy. But it could be something else. Outlook 2000 is set up to automatically check mail on my ISP's POP3 server every x minutes. It is also set up to pass outgoing message to the SMTP server as soon as they are completed. This works fine most of the time. However, occasionally (a couple of times a week), I will notice I haven't gotten any mail at all for a few hours, so I manually check mail and get a popup asking me to re-enter the name of ...

Line chart categoray axis labels issue
Hi, I have two problems (bugs perhaps) that I need o find a way to work around in Excel 2007. They both concern the category (x) axis (text) labels in line charts. I normally shy away from line charts entirely but, in the given instance I need to use them. First question: when you first create the line chart, and when you set the labels for the category axis, Excel automatically rotates the labels to get them to fit as well as possible. However, if you go in to the Format Axis> Alignment>Custom Angle box and enter a value, I can find no way of reenabling Excels automatic selectio...

Dynamics CRM 4.0
Hi, I've modified the format in the system settings screen to be "English (United Kingdom)", however all dates are still appearing in US format. Even when you expand the calendar control it displays incorrectly. Numeric values are correct - showing the pound sign and correct decimal point. I've restarted IIS, made sure all SQL logins are British English and the default regional settings of the server are set to British English. Even rebooted the server but this still hasn't corrected the problem. Can anybody tell me how to resolve this please Thanks I was looking ...

Custom Formatting numbers question
I have a spreadsheet with lot of millions numbers floating around. When I make graphs out of it, there's too much zeros. I don't want to divide all the numbers per 1 million. Is there a way to custom format those numbers with a mask that would take care of that problem for me ? i.e. 7 456 890.98$ would be represented with 7,457 M$ tia Double-click the numbers on your chart. Hit the Scale tab. From the Display units drop-down, choose Millions. ******************* ~Anne Troy www.OfficeArticles.com "Junkyard Engineer" <jevandenbroucke@hotmail.com> wrote in messag...

Changing cell format
I have a worksheet that is populated with data exported from Access. The data in the Access table was serial numbers with an occasional (rare) alpha character. The column was formatted "Text" in Access. When I exported it to Excel, every value in this field (around 3000 entries), has an apostrophe (') inserted at the frontof the cell. Find and Replace does not see the ' How can I remove this so that I can use Fill>Series to populate the gaps in my data (there are many gaps)? Try copying the ' Access character and pasting it into the Replace menu. It could be...

Copying Conditional Format
Is it possible to copy conditional formatting that is already applied to a given cell to another cell? I know that the format is held and continuous formatting is possible, Thanks, Robin Chapple Hi Robin you can copy and paste formatting (including conditional formatting) using either the format painter (big yellow paintbrush toolbar icon) - click on the cell with the formatting, click on format painter, click on the cell where you want the formatting "painted" (double clicking on the format painter turns it on until you turn it off) or by using copy and then edit / paste specia...

Post Install issue!
I have installed CRM to the same Windows 2003 server as AD and SQL. Just for testing - I know what your thinking. Any how after the install when I try to add users I always get "Insufficient rights to add user contact admin" I have gone through the Implementation guide step by step. I have installed this to another Windows 2003 server with the same results. I have looked through about 40 pages of posts on this site and no one seems to have had this issue. Any thoughts? You have not assigned your self a license >-----Original Message----- >I have installed CRM to ...

Exponential number format
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I'm trying to write exponential formulas in excel 2008, but it doesn't recognize the symbol ^ that we use on excel for windows. <br> example: <br> Excel Windows : = 2^2 -> result: 4 <br><br>Excel Mac : = 2^2 -> result: error <br><br>When we import some sheet from windows to mac with this formula works, but when I try to create on mac not recognize. <br><br>My question is: There is any other way to use this Symbol, for this kind of formula? The sam...

Change date format in several worksheets
I have about 50 worksheets in a workbook and would like to change the date format in all. Is there a way to change all at once or must it be done worksheet by worksheet? Select first worksheet. Right-click on the tab and "select all sheets" to group them. Select data range in activesheet. CRTL + A(twice in XL 2003) will select all cells. Make your Format changes. What is done to one sheet will be done to all. DO NOT FORGET! to right-click on any tab and "ungroup" before making any other changes unless you want to change all sheets. Gord Dibben Excel MVP On Sat...