Excel cell formatting 1

[CRXIuser2005]

I have a spreadsheet that was sent to me by a client. In one column (INVOICE NUMBER) the cells appear to have different formatting.

I'm manually having to go to each cell and press the F2 key thenn ENTER and the cell is formatted in number(currency) format.

Does anyone know a way to format the entire column at once?

Then normal cell format option is not working....



Thank you.

MV

"A man is only as happy, as he makes up his mind to be....

 

[SkipVought]

MV,

Select the entire column and format.

Are you changing the Format from Currency to TEXT?

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}

 

[AnotherHiggins]

It sounds to me like you are describing a problem where the data is formatted as text. Even though you might have tried to change the formatting, even though you can check the formatting of the cells and Excel says they are formatted as number, they are really still formatted as text.

Try this:
[ul][li]In a cell to the right of all the imported data, type [blue]1[/blue][/li]
[ul][li](this should be right-aligned, indicating that the cell is formatted as a number)[/li][/ul]
[li]copy that cell[/li]
[li]select the cells that are giving you trouble^[red]*[/red][/li]
[li]Go to Edit > Paste Special > Multiply[/li]
[li]Now try applying a new format to those cells [/li][/ul]

^[red]*[/red] Note that any null cells that you select will be converted to zeros. For this reason I recommend that you don’t select an entire row/column.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[CRXIuser2005]

Is there a way to do the same thing, but intead make the format TEXT or STRING?????

Thank you.

MV

"A man is only as happy, as he makes up his mind to be....

 

[SkipVought]

I was gonna say...

an Invoice Number is really a missnomer -- its a STRING.

You can use the TEXT function for return a STRING from a number in a particular format.

For instance...
[tt]
=TEXT(MyNymber, "00000000")
[/tt]
returns a string of digits from a number left padded with zeros.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}

 

[CRXIuser2005]

THANKS....IT WORKED GREAT.... I'm trying to use this sheet as a DATA TABLE in Crystal Reports..and it seems to be working now.



Thank you.

MV

"A man is only as happy, as he makes up his mind to be....