I have having difficulty with formatting cells also. I want to use 9/06 for
September 2006 and there is no formatting to be able to achieve this. It just
makes it September 6, 2006. I want 9/06. I have tried everything it it does
no good.

"Kevin Vaughn" wrote:

If you still have the original data and it was a csv file, you might want to
change the extension to .txt where you should be given the option of
formatting that data as text. If not, with the cells formatted as text, try
this in a helper column

=TEXT(A2,"yyyy") & "-" & TEXT(A2,"mm") & "-" & TEXT(A2,"dd")
You could then do copy-paste special values and format as text.

HTH
--
Kevin Vaughn


"Todd" wrote:

I exported data from a scheduling program to an excel spreadsheet and data is
now formatted as as date instead of a number. What was 4631-01-10 is now
1/10/4631 and if I convert it to text becomes 997488. How do I convert the
data back into its origonal format? (4631-01-10)

Thanks,

Todd