+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Senior Member
    Join Date
    Aug 2004
    Location
    US
    Posts
    806

    Excel Format Question

    How do I format an excel string so that it reads:

    41-A-3 for example. If I was to type in 41A3 it would display the hyphens and show up as 41-A-3. For example, when I type in ##-#-# and I type 4918 it shows 49-1-8. But I can't remember how to do a character input. I tried ##-@-# but got nothing.

    Anyone know?

    Thanks!
    I7 930i on ASUS Sabertooth X58
    6 gigs Kingston Hyper X
    GForce 570GTX on 1000w Coolermaster

  2. #2
    Nothing To See Here butch81385's Avatar
    Join Date
    Jul 2003
    Location
    PA
    Posts
    15,108
    I think he is looking for a cell formatting solution so that he can type in 41A3 but the cell will display 41-A-3.

    Sorry, ZeR0, but my only suggestion would have been ##-@-# as a custom format but apparently that didn't work...

    Edit: What if you just formatted it as a text cell with @@-@-@, does that work? If so, you would (probably) lose the ability to put them in numerical order, so it is up to you if the gains are worth the losses.
    I don't like signatures.

Quick Reply Quick Reply

If you are already a member, please login above.

What planet do we live on?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Question
    By ClubMed in forum Applications and Operating Systems
    Replies: 0
    Last Post: July 18th, 2005, 07:08 AM
  2. Excel help!! I fight Excel & Excel wins!!!!!!!!!
    By Dooin' it in forum Applications and Operating Systems
    Replies: 4
    Last Post: March 23rd, 2005, 09:35 PM
  3. Excel Question
    By MitaDC in forum Applications and Operating Systems
    Replies: 18
    Last Post: December 16th, 2003, 07:20 PM
  4. Excel question
    By jezzebelld in forum Applications and Operating Systems
    Replies: 14
    Last Post: October 21st, 2002, 11:41 AM
  5. Excel Question.
    By radio1_mike in forum Applications and Operating Systems
    Replies: 1
    Last Post: May 30th, 2002, 01:04 PM

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Copyright 2014 All Enthusiast, Inc