Cell Formatting

[chad13]

I have a cell that I need to show as text: 4213-10-5 (this represents a part number).
When I type it in, it represents it as 10/5/4213.
I've changed the formatting to text, general, etc. and also put an apostrophe in front. The apostrophe works. But I need to save this as a *.csv file for an upload into Oracle. When I save it, then it converts back to the incorrect format.

Any help would be appreciated.

Thanks,

Chad

 

[Smitty]

You can goto Format-->Cells-->Number Format-->Custom--->####-##-#

HTH,

 

[chad13]

Thanks.
The only thing is that there are other formats that need to be maintained in that column.
So the column may contain any combinations of numbers, characters, etc.
I guess the easiest way to explain would be.........they way I type it in is the way I would prefer to have it shown.

Chad

 

[Smitty]

Then you can format it as Text.

 

[chad13]

Thanks, my oversight. I thought I did that.....so simple.

Thanks.