Excel Question

peugeotpeugeot Experienced MentorRegistered Posts: 624
I have a query on Excel which I'm sure some "excel whizz" out there will know.

When I go into "Custom Header" and type, for example, Profit & Loss Reconciliation. Why doesn't the "&" work? It's not the end of the world but I'd be interested to know how to rectify this.

Kind regards
Steve

Comments

  • blobbyhblobbyh Font Of All Knowledge Registered Posts: 2,415
    You're correct Steve - it doesn't work though rather disappointingly I have absolutely no explanation why!

    Peculiarly it will accept a forward slash which you annoyingly can't use when naming a new document hence my AC-DC MP3's rather than AC/DC!!!

    The strange minds of Microsoft eh?
  • peugeotpeugeot Experienced Mentor Registered Posts: 624
    Very odd! It's not something that I'm bothered about I just wanted to know if there was a way around it or why it happens!

    Best regards
    Steve
  • YaziYazi Well-Known Registered Posts: 225
    Hi

    type two &&

    Profit && loss

    and you will get your &

    Yas
  • peugeotpeugeot Experienced Mentor Registered Posts: 624
    Thanks Yazi!!
Sign In or Register to comment.