Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    1,105

    Thanks to Both you fella: 1) Ok.. So, I tried...

    Thanks to Both you fella:
    1) Ok.. So, I tried Formatting to text, and ended up with a column of weird numbers.. so, OBVIOUSLY I have to Format BEFORE I enter the details..
    No problems there, I...
  2. Replies
    5
    Views
    1,105

    Excel Time/date and phone numbers

    Hey all, I did a quick scan through and couldn't find anything to actually suit my issue.

    I am running Office 2007

    Prob 1) When I have a column I wish to run Phone numbers in, I want the 0417,...
  3. Thread: phone detail list

    by kio
    Replies
    3
    Views
    523

    thanks mate: it was playing up at first.. but...

    thanks mate:
    it was playing up at first.. but all good now.. and sorted.. got it all over: and copied and pasted all the details and stuff too...

    Bit of shuffling stuff around and it is all how...
  4. Thread: phone detail list

    by kio
    Replies
    3
    Views
    523

    hey all: I am running 2007 vers. of office...

    hey all:

    I am running 2007 vers. of office
    Some time ago, I did a list of phone numbers and names with SOME details in EXCEL, but want to transfer this info to ACCESS

    The detail is not...
  5. Replies
    8
    Views
    835

    Finally got it.. thanks for all the replies.. ...

    Finally got it.. thanks for all the replies..
    It appears that it is actually an issue with theprogram not being reconfigured for Windows 7.
    The vendor is working toward getting the program...
  6. Replies
    8
    Views
    835

    hey all: I have a clients computer I am trying...

    hey all:
    I have a clients computer I am trying to load our parts catalogue onto.
    On my computer I can right mouse click on the screen - select "personalize" and under "task" select "adjust font...
  7. Replies
    28
    Views
    7,297

    Considering that this is purely a hyperthetical...

    Considering that this is purely a hyperthetical exercise, then we should continue in the abstract.

    Two questions:
    Question one) what is purple and green with yelow polka dots which lives deep...
  8. Thread: column numbering

    by kio
    Replies
    2
    Views
    425

    Thank you Paul! you guys Rock! Us old dinosaurs...

    Thank you Paul!
    you guys Rock!
    Us old dinosaurs will always struggle!! :) http://windowssecrets.com/forums/images/smilies/cheers.gif
  9. Thread: column numbering

    by kio
    Replies
    2
    Views
    425

    I have a document listing 50 odd persons, in four...

    I have a document listing 50 odd persons, in four columns - being : #, name, trade status and work schedule

    My problem is, I am often required to alter my manning list, and have to continually...
  10. Thread: Engraving

    by kio
    Replies
    1
    Views
    394

    Maybe you need to google "fonts" and see if there...

    Maybe you need to google "fonts" and see if there was something specific available, otherwise look at what you can do with some of the extras in paint shop type programs.

    good luck
    kio.
  11. Thread: dating

    by kio
    Replies
    8
    Views
    648

    Cheers chaps!! All good, found out what I...

    Cheers chaps!!
    All good, found out what I needed, and learned a few more things too!!

    much appreciated!
    kio
  12. Thread: dating

    by kio
    Replies
    8
    Views
    648

    For anyone who follows this: I open my doc,...

    For anyone who follows this:

    I open my doc, select the "INSERT" tab, highlight the date area, and then select "Date & Time" tab, which is up the right hand.

    From the menu which opens, I chose...
  13. Thread: dating

    by kio
    Replies
    8
    Views
    648

    Don't you just hate that?? I searched the...

    Don't you just hate that??

    I searched the entire menus, and then, as soon as I read this response, I opened word up, and there it was - sheeeeze!!!

    Thanks, I will find out tomorrow if it works...
  14. Thread: dating

    by kio
    Replies
    8
    Views
    648

    Hey there: OK, I guess this is a very simple...

    Hey there:

    OK, I guess this is a very simple task, but, I cant find it!!

    I have a .doc which has 5 pages in it, three of which are different, and require dating as in "Thursday 7th January...
  15. Thread: Macros/VBA

    by kio
    Replies
    2
    Views
    393

    CELENE!!!!!!!!!!! It is Me.. kio!!! I am back...

    CELENE!!!!!!!!!!!

    It is Me.. kio!!! I am back with Russells crew on the GT's at Dampier...
    Isnt this site just the best???
    at_a2de@hotmail.com.... would LOVE to hear from you.. hope you are...
  16. Thread: lookup xls sheets

    by kio
    Replies
    4
    Views
    900

    Hans: Thanks mate.. that will work fine.. and...

    Hans:
    Thanks mate.. that will work fine.. and "yes" it was a bit of overkill eh!! *smiles*
    Webgenni:
    Thank you also.. still working out what all this stuff can do.. will have to work on what VBA...
  17. Thread: Addition by Name

    by kio
    Replies
    8
    Views
    632

    Pete: recognised your name from camp in...

    Pete: recognised your name from camp in Paraburdoo...
    at_a2de@hotmail.com (long haired mate of Robs)
    kio
  18. Thread: lookup xls sheets

    by kio
    Replies
    4
    Views
    900

    G'day all... ok.. let me try to get this right.....

    G'day all...
    ok.. let me try to get this right..
    I created an .xls program (thanks to Hans)
    each sheet has a chart of company stockmarket codes, with all relevant details.
    Each day, (OR whenever...
  19. Thread: Alerting Excel

    by kio
    Replies
    3
    Views
    433

    It might be better to put the alerts in Outlook...

    It might be better to put the alerts in Outlook as tasks or appointments with a reminder, and to add Outlook to your startup folder (Start | All Programs | Startup, or equivalently C:\Documents and...
  20. Thread: Alerting Excel

    by kio
    Replies
    3
    Views
    433

    ok.. here is my problem... I always get billed...

    ok.. here is my problem...
    I always get billed heeps for late repayments and unpaid bills...

    I can generate an excel sheet with all my details on it.. bills due date..
    Licenses due by date.. ...
  21. Thread: collecting data

    by kio
    Replies
    2
    Views
    335

    Hans.. you are a God!!...

    Hans.. you are a God!! http://windowssecrets.com/forums/images/smilies/smile.gif

    thanks mate.. did exactly what I needed!!

    cheers
    kio
  22. Thread: collecting data

    by kio
    Replies
    2
    Views
    335

    ok.. I have included a spread sheet of...

    ok.. I have included a spread sheet of stockmarket data.. [attachment=85292:portfolio_ex.xlsx]

    1) I want this to add the (-) and (+) values seperately as well as the sum in (J22) these will be...
  23. Replies
    5
    Views
    394

    Re: counting days (2007)

    Jezza: thank you for that..
    I have added that to my library also.. tried it, and it seems to work ok too ..
    cheers
  24. Replies
    5
    Views
    394

    Re: counting days (2007)

    Further to the chart, to eliminate the ####### or #value# on incompleted orders, the formula reads
    =IF(L2<>"",(K2-C2),"")
    where L2 is the sold unit cell K2 is the sold date cell and C2...
  25. Replies
    5
    Views
    394

    Re: counting days (2007)

    Hans: Thank you!
    I was thinking It just HAD to be so damned long and complicated.. Me of little faith!
    B2 and B3 cells were both formatted to the same date format, and the target cell was formatted...
Results 1 to 25 of 29
Page 1 of 2 1 2