Unwanted numbers in cells [Range Functions]

[charlesj]

Hi:

Just an ole okie that is confused - When trying to make a listing of items (numbers in cells ie: 30E1, 31L1, etc) after row 17 I think a number goes in the cell that I dont want (30-002 or some thing like that. What up?

[Hagar Delest]

Have you tried to change the cell Format and set it to Text?

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.

[kingfisher]

If that does not fix it, what exactly do you wish to enter and what exactly happens when you try?