Excel and Numbers

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
 
B

bgeier

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
How do I stop Excel from converting a numerical entry to a date? 4
Excel Vba to change displayed year automatically. 14
Conditional formatting in Excel 2010 2
how do i stop excel from converting numbers entered into a date 2
MOD and Ceiling formula used to round up and down to 49 and 99 3
Unique numbers entered once only 5
Shared document will not open for user 1

Top