Forum home » Delegate support and help forum » Microsoft Excel Training and help » How do you stop the figures being entered as decimal figures
|
|
|
The UK's most regular 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. |
How do you stop the figures being entered as decimal figures
Resolved · Urgent Priority · Version 2003
Reply Tue 9 Sep 2008, 09:02Delegate Joy said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Tue 9 Sep 2008, 09:15Delegate Joy said...
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
Reply Tue 9 Sep 2008, 09:32Delegate Joy said...
RE: How do you stop the figures being entered as decimal figures
I also have at the bottom of my screen, where the NUM lock toolbar is, a FIX icon? What is that?
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
Reply Tue 9 Sep 2008, 10:40Delegate Joy said...
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
|