PROBLEM: when typing a figure into a cell in Excel the figure is displayed as a date?
SOLUTION: quickly change the format of the cell back to a format that displays numbers, not dates.
Excel – Remove formatting from a cell
As soon as you type a date into a cell Excel automatically changes the cell format to be a ‘Date’ format. This can through up a bit of a challenge if you later delete the date and replace it with a number.
Join the 'Excel at Work Insiders' group today!
100% free. Join now and unlock offers exclusive to this group!
Receive tips and guidance to help you SAVE TIME, WORK SMARTER and IMPROVE YOUR UNDERSTANDING of Microsoft® Office.
The problem is that the cell’s formatting remains even when you delete the content. Therefore every time you type a number into the cell it will automatically be formatted as a date.
To change the cell format so that your number is displayed, and not a date:
- Select the cell (or range of cells) that are giving you grief.
- On the Home tab from the Number group click the drop down arrow on the Number Format command. Select the Number format.
3. Your cell will now have the Number format applied and your number will be displayed.
Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand.
She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.
If you enjoyed this you may also enjoy...
Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter. It doesn’t matter if I’m delivering a Stage 1 or a Stage 3 Excel training course – when I’m demonstrating to the class I whip around the screen, format, select and modify and update using shortcut
If you share Excel files outside of your organisation you’ll enjoy this post where I share with you how to remove Excel formulas and keep the results so that you can confidently send a file knowing you aren’t disclosing confidential information inside of your formulas.
Learn how to move, copy and paste information in Excel. Once you have mastered Cut, Copy and Paste you will find yourself shifting data around easily and reusing copied data, saving you the need to recreate the same information again. All Windows applications have access to the Windows Clipboard. This is a special area used for
Formatting lets you change the appearance of data to control exactly how Excel will display the data on a worksheet. An example of formatting is to add dollar signs, percentage signs and decimal places to Excel data. Join the ‘Excel at Work Insiders’ group today!100% free. Join now and unlock offers exclusive to this group!Receive tips and guidance
Learn how to preview your work before printing and how to print all or part of an Excel worksheet. Join the ‘Excel at Work Insiders’ group today!100% free. Join now and unlock offers exclusive to this group!Receive tips and guidance to help you SAVE TIME, WORK SMARTER and IMPROVE YOUR UNDERSTANDING of Microsoft® Office. envelope envelope Join