Excel Cell Formatting

[Prognewb]

Using Excel 2007.
I have a list of 2000+ customer numbers, that I'm trying to format to include open and closing quotes and a comma after each one; '798789',

I've been highlighting the entire column, selecting Format Cells, Custom, and putting in '######', to format the column. The formatting is only showing up when I go to each individual cell and double click on it. Daunting task for 2000 cells.

I've done this sort of formatting in the past and it's worked as intended, but now I don't remember if I'm doing something wrong or not. I've done the whole google thing and according to what I've seen I am doing it correctly. Any ideas would be helpful. Thanks!

 

[Cordeiro82]

You could use the concatenate function.

If all your customer records are in column A then in B1 you enter =concatenate("'",A1,"'"). That should work.

 

[SkipVought]

Hi,

FORMATTING changes NOTHING!

When you Format a range of cells, it is only the DISPLAY that may change. The underlying VALUE remains UNCHANGED.

If you want the values in the range, delimited with single quotes, you must do that in a SEPARATE COLUMN, using a formula like...
[tt]
="'"&A1&"'"
[/tt]
as Cordeiro82 suggested.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[AnotherHiggins]

-> and a comma after each one

It sounds like you're trying to create a comma separated file. (I just sounded like that stupid paper clip for a second there....)

In case that's what you're after, you can just go to Save As and in the Save as type select CSV.

You'll still need to append the single quotes as noted above.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Prognewb]

That did it... I should have been clearer as far as punctuation, as I needed a comma after the second quote, but I figured it out and got the result I needed.
I swear, sometimes dealing with Excel makes me feel like I just fell off the turnip truck.

Thanks for your help, much appreciated!