• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format Cell

S

SteveT

New Member
Hi all,


I have a cell that has data validation set to be = a list of values like this:

"01008, English as a Second Language"


When a user picks a value, i want the Cell to only display 01008 with formats. I want to do this because the file will be saved as Tab Delimited which should only save the shown values.


Is there anyway to do this without VBA and without Macros? I was thinking of a custom format, but can seem to make it work. Thanks in advance
 
No. In your current setup, the 01008 is part of a text string, which can't be affected by cell formats. =(


Non-VB method would be to have a helper column with formula:

=LEFT(A2,5)


VB method would be to have a quick macro go through and strip off the end of each value.

Do note, that even if there was a way to format the cell to only display part the of the value, the saved file would save the value, not just what's displayed.
 
Thanks luke, that save me time from continuing to look for a solution. Think i will just delete the text part of the string and leave it as the value.
 
You must log in or register to reply here.
Back
Top