number changes to date ... how do I change

  • Thread starter Thread starter Kristola
  • Start date Start date
K

Kristola

I am trying to do an "age" range:
1-9
10-19
20-29

Instead I get September 9, 2004
or October 19

I can't figure out how to change it.

Please help! Thank you!

kk
 
Format->Cells->Number

Change the type to Text, and it should keep everything the way you want
it. If you don't specify a type, Excel takes a guess based on what you
enter.

Hope that helps.

-Bob
 
Back
Top