Thread: How do I change Excel so it doesn't autochange numbers I put in?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Carole O Carole O is offline
external usenet poster
  
Posts: 69
Default How do I change Excel so it doesn't autochange numbers I put in?
Highlight the cell you want to change i.e. 10/17. Go to the top toolbar -
Format, Cell,Number, Date and pick the format you want. For the 20.00 it's
Format, Cell, Number, Number, and on the right, select 2 decimals.

Hope this helps!

Carole )

"luluandkirk" wrote:

I am becoming frustrated with Excel because when I input numbers, such as
10/17, it changes it to 17-Oct. Also, when I input 20.00, it changes it to
20. I don't want this to change. Is there a setting I can change?
Reply With QuoteReply With Quote