Forum Home» Techie Stuff

Numbers on a MacBook Pro

New Post Advanced Search

Numbers on a MacBook Pro

edited 30 November -1 at 1:00AM in Techie Stuff
9 replies 627 views
schiffschiff Forumite
19.6K posts
Part of the Furniture 10,000 Posts Name Dropper
✭✭✭✭✭
edited 30 November -1 at 1:00AM in Techie Stuff
It's only a small thing but I find it very irritating. I type in a date in the format 21/5/19, it comes out as 21 May 2019 which is what I'm happy with, but in some of the boxes there appears a small plus sign + in a box of its own in the bottom right hand corner. It only happens some of the time, so I finish up with some boxes with just the date and some with the irritating + :mad:

What am I doing wrong and how can I avoid it happening?

TIA

Replies

  • DoaMDoaM Forumite
    10.9K posts
    10,000 Posts Fifth Anniversary Name Dropper Photogenic
    ✭✭✭✭✭
    I had to read the post a few times to work it out ... Numbers is the Apple version of Excel.

    No idea, sorry. Presumably there's an option to check the cell format? (Or select a cell you know is correct, click the Numbers equivalent to Format Painter and then select the other incorrect cell or cells).
    Diary of a madman
    Walk the line again today
    Entries of confusion
    Dear diary, I'm here to stay
  • Zola.Zola. Forumite
    1.6K posts
    Eighth Anniversary 1,000 Posts Name Dropper
    ✭✭✭
    Excel and Google sheets does that too does it not?
  • AnotherJoeAnotherJoe Forumite
    17.6K posts
    10,000 Posts Fourth Anniversary Name Dropper Photogenic
    ✭✭✭✭✭
    Try this.
    Select a cell you like the format of.
    Do CMD ALT C
    Select the range of cells you want to have that format including ones with a +
    Do CMD ALT V
  • schiffschiff Forumite
    19.6K posts
    Part of the Furniture 10,000 Posts Name Dropper
    ✭✭✭✭✭
    I don't think that's it. I had the brainwave to copy and paste an OK cell and amend it. Tried it both in the cell and up top and the blasted + came back. It must be cell related and for specific cells. But how I've no idea.

    Even typing in 27 May 2019 directly doesn't get rid of it.
  • AnotherJoeAnotherJoe Forumite
    17.6K posts
    10,000 Posts Fourth Anniversary Name Dropper Photogenic
    ✭✭✭✭✭
    Where is the +? In the cell with the date?
  • schiffschiff Forumite
    19.6K posts
    Part of the Furniture 10,000 Posts Name Dropper
    ✭✭✭✭✭
    I don't believe it !!! When I widen the cell it disappears.

    Feel a bit embarrassed now :o
  • AnotherJoeAnotherJoe Forumite
    17.6K posts
    10,000 Posts Fourth Anniversary Name Dropper Photogenic
    ✭✭✭✭✭
    I was just going to paste this
    The plus sign means the content of the text box is larger than the box. It could be a space or paragraph break or a character. Turn on Show invisibles > select the box > drag the square handle in the corner on the box to make the box larger > delete the offending thing if there is one.:rotfl:
  • schiffschiff Forumite
    19.6K posts
    Part of the Furniture 10,000 Posts Name Dropper
    ✭✭✭✭✭
    Thank you. The strip along the bottom showing my main links has now disappeared. It appears when I scroll down off the page but then disappears.:rotfl:
  • ChinoChino Forumite
    1.5K posts
    Eighth Anniversary 1,000 Posts
    ✭✭✭
    Zola. wrote: »
    Excel and Google sheets does that too does it not?
    Excel does not. No idea about Google Sheets.
Sign In or Register to comment.

Quick links

Essential Money | Who & Where are you? | Work & Benefits | Household and travel | Shopping & Freebies | About MSE | The MoneySavers Arms | Covid-19 & Coronavirus Support