Excel and Numbers

  • Thread starter Thread starter Cathy C
  • Start date Start date
C

Cathy C

I have a client using an Excel spreadsheet to log information. One column
contains dates in various formats, i.e., 2005, 10/11/99, Fall 2004, etc.
When she enters a date in 10/11/99 format, it converts it to numbers. I had
her forward it to me and the data remains as it was entered. What do I need
to do to get her version of Excel 2003 to leave the data as entered?

Thanks,

Cathy
 
Sounds like her column formats set to general.
Try having her change it to text, that should keep the cells as they
are entered
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

bingo 5
Conditional formatting in Excel 2010 2
Help on conversion 3
lookup/index/match - help! 3
How do I stop Excel from copying date format from cell above? 2
LOOKUP function between two dates in Excel 2007 6
how do i stop excel from converting numbers entered into a date 2
Problem with formula in grouped sheets 2

Back
Top