Unwanted numbers in cells [Range Functions]

Discuss the spreadsheet application

Unwanted numbers in cells [Range Functions]

Postby charlesj » Sat Jan 26, 2008 6:21 am


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?
Posts: 1
Joined: Sat Jan 26, 2008 6:11 am

Re: unwanted numbers in cells

Postby Hagar Delest » Sat Jan 26, 2008 9:09 am

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.
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Posts: 29079
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: unwanted numbers in cells

Postby kingfisher » Sat Jan 26, 2008 9:15 am

If that does not fix it, what exactly do you wish to enter and what exactly happens when you try?
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Return to Calc

Who is online

Users browsing this forum: Villeroy and 33 guests