Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.38 seconds.

  1. Replies
    21
    Views
    182

    Re: excel 2002 convert numbers to mathematical

    Remove the hyperlinks then do a Replace with the $ in the replace with box and the other box blank.

    https://app.box.com/s/8e8ca9jhuvwkemtn4vyof7xaggs45c3t

    then format your cells as desired.
  2. Replies
    21
    Views
    182

    Re: excel 2002 convert numbers to mathematical

    I think we are probably back to what joeu2004 wrote back in post number 4.

    .

    If you can upload your file to www.box.com (the personal version is free but a bit hard to navigate to these days)...
  3. Replies
    21
    Views
    182

    Re: excel 2002 convert numbers to mathematical

    What do you mean "we retype the numbers"? you select the numbers in the spreadsheet, paste the one line of code Rick posted in the Immediate window and press Enter.

    There shouldn't be any retyping...
  4. Replies
    21
    Views
    182

    Re: excel 2002 convert numbers to mathematical

    Are you saying that post 11 is the result you get when you carry out the instructions above by Rick?
  5. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    First of all this

    With scrws
    is still wrong and I can't see how it would run without erring until it is corrected. It should be
    srcWS

    In this line the colored bits are declared twice which...
  6. Replies
    5
    Views
    30

    Re: Date / time conversion to dd/mm/yy

    Nothing to be sorry about :rofl:
  7. Replies
    11
    Views
    116

    Re: Removing Duplicates with Timestamp

    Removed as on testing SuzB17 appears to be correct.
  8. Replies
    5
    Views
    30

    Re: Date / time conversion to dd/mm/yy

    Edit: Too slow, deleted as no benefit over what Special-K99 has posted.
  9. Replies
    11
    Views
    116

    Re: Removing Duplicates with Timestamp

    With the original data (after the timestamp is removed) if you change the format of the cells to a number format rather than a date format what do you get returned?
  10. Replies
    21
    Views
    182

    Re: excel 2002 convert numbers to mathematical

    I think you missed the Immediate Window part, if you can't see it in the VBE click the View icon then click Immediate Window, it normally appears at the bottom of the window where you type your code....
  11. Replies
    7
    Views
    71

    Re: Help me with entering times in Excel

    Yes but the act of adding AM to the cell doesn't turn it to text, it is the lack of the space with the AM so this statement



    is incorrect.

    Data validation though from the OP's post would do...
  12. Re: "Be careful! Parts of your document may include personal information that cannot be removed by the document inspector"

    In Excel Options|Trust Center|Privacy Options try unchecking 'Remove personal information from file properties on save'.
  13. Replies
    7
    Views
    71

    Re: Help me with entering times in Excel

    halesowenmum, you can always use Data validation to force the users to enter it in a recognised time format.
  14. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    Except it doesn't :biggrin: besides obviously I would already know what outcome it gives me before I posted it.

    Anyway I already stated I can't go any further without more info or a copy of the...
  15. Replies
    7
    Views
    71

    Re: Help me with entering times in Excel

    If I enter 10 AM in a cell (with the space) it doesn't turn it into text, it remains in time format and =ISNUMBER(The cell reference) returns TRUE.
  16. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    Yes it would, one implies that it hadn't been tested.

    Afraid I have nothing to add currently as the code I posted printed out 3 pages with my data so unless you can provide any other info I don't...
  17. Replies
    2
    Views
    48

    Re: Delete entire row

    Maybe....


    Sub delrow()
    Dim x As Long
    Application.ScreenUpdating = False
    For x = Range("H" & Rows.Count).End(xlUp).Row To 2 Step -1
    If Not IsNumeric(Left(Trim(Cells(x,...
  18. Re: if date falls on weekend, roll to Monday

    See Ricks response to the OP's duplicate (well strictly speaking this was the duplicate as they posted the other thread before post number 7) here

    but the correct answer is still to enter the...
  19. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    The main difference is the original code loops through each cell in each column and copies it whereas the amended code copies the complete range in each column and copies it in one go

    For...
  20. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    By do you mean it did just... when I tested it.... probably just the grammar but not reading right to me.
  21. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    You haven't replaced it with what I posted... look again.
  22. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    With scrws needs changing to
    With srcWs
  23. Replies
    9
    Views
    154

    Re: Copy & Paste Cell formats

    Your Autofilter only looks at one column... Column G.
    If you mean rows then it looks at cells that are greater than the start date so yes a blank cell will be ignored.
  24. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    What happens with...


    Sub PrintSelection()
    With ActiveSheet.PageSetup
    .PrintArea = ActiveSheet.Range("A1").CurrentRegion.Address
    .Zoom = 100
    End With
    ...
  25. Replies
    9
    Views
    154

    Re: Copy & Paste Cell formats

    If that is the result that you get with that code then your Excel is acting very oddly :eeek: how are your cells formatted? normally or with conditional formatting? and what formatting do you have...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4