|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 30th, 2006, 11:23 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
1 becomes 10, how can I stop this
Iv'e been working with basic formulas and worksheets for a short time. Today
I opened a saved sheet and found that when I use a number and enter to the next cell, the number gains a zero ie 1 becomes 10. If anyone can help out with this I'd be very grateful. Many thanks DB 
|
|
#2
June 30th, 2006, 11:45 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
1 becomes 10, how can I stop this
check for the format of cells. right click on the cell in which 1 turns to 10 select Format cell and see for its format and change it to yor required format according to your data. HerbalDave Wrote: Iv'e been working with basic formulas and worksheets for a short time. Today I opened a saved sheet and found that when I use a number and enter to the next cell, the number gains a zero ie 1 becomes 10. If anyone can help out with this I'd be very grateful. Many thanks DB -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=557254
|
|
#3
June 30th, 2006, 11:46 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
1 becomes 10, how can I stop this
Nel post
*HerbalDave* ha scritto: Iv'e been working with basic formulas and worksheets for a short time. Today I opened a saved sheet and found that when I use a number and enter to the next cell, the number gains a zero ie 1 becomes 10. If anyone can help out with this I'd be very grateful. Many thanks DB Try with this (I'm not sure...): Menu Tools, Options, tab Edit, deflag Fixed decimals -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy
|
|
#4
June 30th, 2006, 12:33 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
1 becomes 10, how can I stop this
HerbalDave wrote: Iv'e been working with basic formulas and worksheets for a short time. Today I opened a saved sheet and found that when I use a number and enter to the next cell, the number gains a zero ie 1 becomes 10. If anyone can help out with this I'd be very grateful. Many thanks DB Hi HerbalDave If custom formats aren't the probelm, check to see if a macro is changing the cell. Regards Steve
|
|
#5
June 30th, 2006, 02:06 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
1 becomes 10, how can I stop this
Thanks to all that answered. By opening: Tools, Options, Tab Edit and
De-flaging fixed decimals, the problem was solved. Many Thanks DB "HerbalDave" wrote: Iv'e been working with basic formulas and worksheets for a short time. Today I opened a saved sheet and found that when I use a number and enter to the next cell, the number gains a zero ie 1 becomes 10. If anyone can help out with this I'd be very grateful. Many thanks DB
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Tab at 0.63 cm | Geoff | Page Layout | 10 | November 9th, 2005 02:15 AM |
| Get song to stop playing in view slide show mode | mary amy | Powerpoint | 1 | December 31st, 2004 01:23 AM |
| Stop Statement Doesn't Stop | drwip | General Discussion | 1 | December 2nd, 2004 11:10 PM |
| Stop Recording toolbar does not open in Excel 2003. | Lastword24 | Worksheet Functions | 4 | September 7th, 2004 10:38 PM |
| Can't stop messages being deleted despite rules | Karl Engel | Outlook Express | 1 | July 6th, 2004 06:14 AM |
Linear Mode
