Thread: Excel Format Question
December 17th, 2006, 05:08 PM #1
- Join Date
- Aug 2004
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.
Thanks!I7 930i on ASUS Sabertooth X58
6 gigs Kingston Hyper X
GForce 570GTX on 1000w Coolermaster
December 18th, 2006, 09:08 AM #2
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By ClubMed in forum Applications and Operating SystemsReplies: 0Last Post: July 18th, 2005, 07:08 AM
By Dooin' it in forum Applications and Operating SystemsReplies: 4Last Post: March 23rd, 2005, 09:35 PM
By MitaDC in forum Applications and Operating SystemsReplies: 18Last Post: December 16th, 2003, 07:20 PM
By jezzebelld in forum Applications and Operating SystemsReplies: 14Last Post: October 21st, 2002, 11:41 AM
By radio1_mike in forum Applications and Operating SystemsReplies: 1Last Post: May 30th, 2002, 01:04 PM