98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » How do you stop the figures being entered as decimal figures
How do you stop the figures being entered as decimal figures
Resolved · Urgent Priority · Version 2003
Joy has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
How do you stop the figures being entered as decimal figures
I don't know what button I have pressed but when I enter a whole number in the cell, it converts it to a decimal number! How do I stop it from doing this?
RE: How do you stop the figures being entered as decimal figures
Hi Joy
thanks for your question. It sounds like the number formatting for the cell has been changed to show decimal places. Try this:
right click on the cell in question then from the menu that appears choose format cells then click the number tab and finally choose a number format from the list. For example you might choose general or number with 0 decimal places.
Hope this helps!
Kind regards,
Andrew
RE: How do you stop the figures being entered as decimal figures
Hi Andrew
I tried this yesterday and when I do change it to the number format, it converts all my numbers to 0!
My boss has opened the file from his PC and it's fine.
I am going crazy as I don't know what else it could be!
Joy
RE: How do you stop the figures being entered as decimal figures
Hi Joy
I can understand how you feel, i have a little something you could try, select the cells then go to the edit menu, and choose clear then click formats, this may do the trick!!!
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
RE: How do you stop the figures being entered as decimal figures
Mark, Thanks for this.
Before I received your email, I was calling some of my excel buddies and one of them suggested the Tools/Options/Edit and there is a section on decimal places and I had to convert that back down to 0!
I don't see how I managed to do that using the shortcut key!
All is good now though - thank you!
Joy
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using the Quick Access Toolbar in Excel2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |