stop fractions changing to dates

J

John

trying to put 5/5 into a cell and automatically changes to 5-may. how do I
stop this?
 
D

Dave Peterson

Preformat the cell as text
(Format|Cells|Number tab in xl2003 menus)
Then do the data entry

or start your entry with an apostrophe:
'5/5
 

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

how to stop fractions in a columm automatically changing to dates 5
Excel Excel and Fractions 3
How do I stop fractions from being reduced? 3
Pasted fractions converted to dates 6
Stop date conversion in Excel when pasting 3
How to prevent Excel converting imported fractions into dates 6
How do I stop Excel from 'interpreting' my data? 7
How do I display exact fractions instead of decimals? 2

Top