Numbers - date and left margin

Discussion of general issues, not related to a specific Mac or iDevice operating system.
Post Reply
Kirsten Ruhl
Forum Member - Level 3
Forum Member - Level 3
Posts: 151
Joined: Fri Apr 15, 2011 6:45 pm

Numbers - date and left margin

Post by Kirsten Ruhl » Sun Aug 21, 2011 3:54 pm

Encountering two problems in Numbers spreadsheets:

1) I enter "08-05" in a cell and it insists on giving me "Aug 5, 2011".
I simply want "08-05". I want Numbers to treat it as if it were a word and not something for it to calculate on.
(the "08-05" imported from Appleworks stays as such - it is only new entries that are affected.)

2) My left hand cells suddenly do not show their extreme left edge on screen.
It prints the whole left cells fine - just refuses to show onscreen unless I click outside the document and get rid of the row and column headings.
In other words, the row numbers cover the left tip of the whole A-column.

User avatar
Stephen Hart
Forum Member - Level 5
Forum Member - Level 5
Posts: 3132
Joined: Thu Apr 07, 2011 10:09 am

Re: Numbers - date and left margin

Post by Stephen Hart » Sun Aug 21, 2011 4:19 pm

I'm no spreadsheet maven, but it seems that you want a spreadsheet (or database) to treat a field as text, you need to format that field as text, not as date or number.
"Design is not just what it looks like and feels like. Design is how it works."
Steve Jobs

Kirsten Ruhl
Forum Member - Level 3
Forum Member - Level 3
Posts: 151
Joined: Fri Apr 15, 2011 6:45 pm

Re: Numbers - date and left margin

Post by Kirsten Ruhl » Sun Aug 21, 2011 4:44 pm

Yes, Stephen, I agree that solution to problem number 1 is to format as text.
In Appleworks I know how to do that.
How in Numbers?
Help doesn't help...

Question #2 open and still a puzzle.

Kirsten Ruhl
Forum Member - Level 3
Forum Member - Level 3
Posts: 151
Joined: Fri Apr 15, 2011 6:45 pm

Re: Numbers - date and left margin

Post by Kirsten Ruhl » Mon Aug 22, 2011 9:59 am

I woke up this morning with fresh courage and ideas for these two problems.

1) I located in the Inspector a Cell Inspector who knew how to tell cells to behave like text containers.

2) I wondered if my
"obscuring of the left edge of column A's text with the numbers of row headings"
could be related to Print View...
It was. As soon as I left print view, I could see all of the columns A's text.

Problems solved. :lol:

User avatar
Richard Serkes
Forum Member - Level 5
Forum Member - Level 5
Posts: 1027
Joined: Thu Mar 31, 2011 9:21 pm
Location: Port Angeles, WA

Re: Numbers - date and left margin

Post by Richard Serkes » Mon Aug 22, 2011 11:14 am

Good news and congratulations on the fix.
---
Always burn your bridges. You never know who's coming up from behind.

User avatar
JerryFreilich
Forum Member - Level 3
Forum Member - Level 3
Posts: 424
Joined: Mon Apr 04, 2011 6:35 pm
Location: Bend, OR

Re: Numbers - date and left margin

Post by JerryFreilich » Mon Aug 22, 2011 7:22 pm

For what it's worth... I rarely use Numbers so I'm not too familiar with it... but in Excel, this same task is done by beginning text cells with a quotation mark (") which causes the cell content to be displayed as text. You can also use the Format menu to do it, but sometimes it gets tricky and the formatting keeps clearing. Glad you found the Inspector fix!

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests