Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Post-Format Worksheets To Text.. (WindowsXP - Office2003 Pro)

    Good morning all,

    I receive workbooks with many sheets all set to "General" which means, that some entries are treated/evaluated by Excel according to its rules...

    I need need all entries set to "text" in order to process them...

    The easiest way would be to ask the sender to format their tables as text in the first place but so far I have not succeeded...

    So, is there any fast way to "post-process" those sheets?!

    And, the sheet names have weird names, nothing like sheet1 to sheet53 or similar...

    Thank you and best regards...

    Wolfgang

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Post-Format Worksheets To Text.. (WindowsXP - Office2003 Pro)

    You can format all cells in all sheets as text like this:
    - Right-click any sheet tab.
    - Click on 'Select all sheets' in the popup menu.
    - Press Ctrl+A to select all cells.
    - Select Format | Cells... or press Ctrl+1.
    - If necessary, activate the Number tab.
    - Select Text in the list of categories.
    - Click OK.
    - Click on any cell.
    - Click on another sheet tab (this is important, otherwise all sheets will remain selected).

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Post-Format Worksheets To Text.. (WindowsXP - Office2003 Pro)

    Hi Hans....

    this is exactly what I want to accomplish....

    Can this be automated by some macro?!

    Thanks,
    Wolfgang

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Post-Format Worksheets To Text.. (WindowsXP - Office2003 Pro)

    In a macro, it is even simpler:

    Sub SetTextFormat()
    Dim wsh As Worksheet
    For Each wsh In Worksheets
    wsh.Cells.NumberFormat = "@"
    Next wsh
    End Sub

    If you put this macro in your Personal.xls, it will always be available. (See Legare Coleman's <!post=Personal.xls Tutorial,118382>Personal.xls Tutorial<!/post> for info about creating/using Personal.xls)

  5. #5
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Post-Format Worksheets To Text.. (WindowsXP - Office2003 Pro)

    Super, Hans....

    Thank You very much and have a nice day...

    Wolfgang

Posting Permissions

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