Search:

Type: Posts; User: MartinM; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    8
    Views
    170

    In the cell format dialog select Left (Indent)...

    In the cell format dialog select Left (Indent) and in the Indent: box choose how far from the left you want the characters to be.
  2. Replies
    8
    Views
    170

    Can't you simply left-align the cells ?

    Can't you simply left-align the cells ?
  3. Replies
    3
    Views
    78

    Perfect, thanks. I find the explanations for...

    Perfect, thanks.

    I find the explanations for the number formatting quite hard to follow, but the examples mostly clear it up.
  4. Replies
    3
    Views
    78

    OK, answered my own question ! I needed...

    OK, answered my own question !

    I needed "###,#".

    So my next question is . . . where is there a comprehensive list of the possibilities for the FORMAT statement - getting the answer above took...
  5. Replies
    3
    Views
    78

    Formatting numbers with VBA

    I am trying to use a VBA FORMAT statement to display numbers with no decimal places and the comma separator.

    "00" gives me the correct display but without the commas

    "000,0" gives me the commas...
  6. Good news, thanks for posting back. Dontcha like...

    Good news, thanks for posting back.
    Dontcha like software that simply works !
  7. Replies
    10
    Views
    293

    Dear Howard, I have reviewed the many posts...

    Dear Howard,

    I have reviewed the many posts you have made concerning Excel on this and other forums and I conclude that you have a complex array of spreadsheets - linked by and containing VB...
  8. You use Companion Link - not free but very good.

    You use Companion Link - not free but very good.
  9. Replies
    4
    Views
    153

    Type outlook calendar change temperature to...

    Type

    outlook calendar change temperature to celsius

    into Google and look at the first hit
  10. Replies
    10
    Views
    293

    You will probably get your answer here: ...

    You will probably get your answer here:

    http://www.mrexcel.com/forum/excel-questions/800934-list-files-folder-sub-folder.html
  11. After some research I opted for Companion Link....

    After some research I opted for Companion Link.
    It works beautifully and the support is also very good - I had a longstanding Outlook issue which they successfully helped me to resolve.
  12. Replies
    5
    Views
    254

    http://www.companionlink.com/ - as recommended on...

    http://www.companionlink.com/ - as recommended on this forum recently - works brilliantly for me.

    And their support (by email) is prompt and effective.
  13. Replies
    1
    Views
    180

    OK, so I've been hunting round the Internet and...

    OK, so I've been hunting round the Internet and stumbled on the advice to press CTRL 6. This showed a fuller set of folders in the LH pane, which lists BOTH address books - Addresses and Contacts.
    ...
  14. Thanks Steve, but it's the change in relative...

    Thanks Steve, but it's the change in relative position which I am guarding against.

    Your first method does that for me.
  15. Perfect ! Thank you Steve, and for the...

    Perfect !

    Thank you Steve, and for the alternative ideas which I'll think about.
  16. VBA: changing a formula when columns are inserted / deleted

    I know I should be able to work this out, but I'm tired after a day of dancing and cycling !

    Anyway, on to the facts.

    I have a complex VBA routine which uses named ranges to ensure that if...
  17. Replies
    5
    Views
    321

    Does your PC have the correct time zone selected...

    Does your PC have the correct time zone selected in Regional Options settings ? Sounds as if you might be 2 hours out.
  18. Let's assume that the date you are starting from...

    Let's assume that the date you are starting from is in cell A1.

    If you are happy to ignore the effects of leap years then you can use the simple formula =A1-365

    If you need to be exact, you can...
  19. Replies
    1
    Views
    180

    Invisible contacts !

    Outlook 2003

    Sometime ago I "lost" my contacts. When I tried to create a new list Outlook said that Contacts already existed, so I named the new list Addresses, imported the contents from a backup...
  20. Replies
    4
    Views
    350

    http://www.microsoftstore.com/

    http://www.microsoftstore.com/
  21. Replies
    11
    Views
    1,545

    After a bit of research into the helpful...

    After a bit of research into the helpful suggestions here I went for CompanionLink.

    More expensive than gSyncit but so easy to buy, to set up and to use that I'm happy with the higher cost.

    2...
  22. Thread: Copy & Paste

    by MartinM
    Replies
    4
    Views
    171

    Probably not a MS problem. Some possibilities:...

    Probably not a MS problem.
    Some possibilities:
    * A dirty keyboard, or not pressing firmly enough
    * CTRL C doesn't work when a cell is in edit mode, or when the workbook isn't the active Window...
  23. http://office.microsoft.com/en-gb/excel-help/calcu...

    http://office.microsoft.com/en-gb/excel-help/calculate-a-compound-annual-growth-rate-cagr-HP001122506.aspx
  24. Replies
    11
    Views
    1,545

    Windows XP market share is 25.27% as of last...

    Windows XP market share is 25.27% as of last month so there a more than a few million users who can't be bothered with the update carousel.

    I'm one of them: XP/O2003 is functional, stable and has...
  25. Replies
    11
    Views
    1,545

    Thanks Superman. However I am using Outlook 2003...

    Thanks Superman.
    However I am using Outlook 2003 and I wanted 2-way synch.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4