Home |
Search |
Today's Posts |
#1
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
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
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To Stop or Not to Stop | Excel Discussion (Misc queries) | |||
Stop Opening Book1! | Excel Discussion (Misc queries) | |||
Stop the line when 0 is reached | Charts and Charting in Excel | |||
Breakpoint will not stop Excel subroutine | Excel Discussion (Misc queries) | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions |