excell cell formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell cell formatting

Excell cell formatting

resolvedResolved · Low Priority · Version Standard

Marthie has attended:
Excel Intermediate course
Excel Advanced course

Excell cell formatting

How do I get rid of the !box next to numbers enterred as text?

RE: Excell cell formatting

Hi Marthie, Thank you for the post, in answer, to stop the info box from appearing, go to the menu command, View. Error Checking, and deselect the box Number Stored as Text. I hopw that helps, Best Regards Pete


 

Excel articles

Please browse our web site to find out more about
microsoft-excel-courses and other training courses.

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.