+ Reply to Thread
Results 1 to 3 of 3

Find Column with hours in the header and format it accordingly

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Question Find Column with hours in the header and format it accordingly

    Hi,

    what I am tying to achieve is to locate all columns in my work sheet which contain the word ‘Hours’ in the header e.g. ‘Billable Hours’, ‘Hours Worked’, ‘Total Hours’ which can be located any where between columns ‘A1 to ‘IV1’ and then format them to a number with two decimal places.

    Any help would be greatly appreciated

    Excel version 2003

    Many thanks


    Rob
    Rob

  2. #2
    Forum Contributor
    Join Date
    01-05-2004
    Location
    Helsinki, Finland
    Posts
    100
    Hi,

    something like this perhaps?

    Please Login or Register  to view this content.
    - Asser

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Hello Rob,

    Please don't "crosspost" without a link, it breaks our forum rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1