Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent the cell from changing the number I enter?
Everytime I enter a number (18 digits) into the cell it changes it to a
different number. I've tried changing the number format in the formatting menu and that didn't solve it (went into Format, Cells, Number and selected 0 decimal places). Does anyone know how to fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent the cell from changing the number I enter?
Hi
Type an apostrophe ' before you enter the number, it won't show in the cell. Mike "Littlestar29" wrote: Everytime I enter a number (18 digits) into the cell it changes it to a different number. I've tried changing the number format in the formatting menu and that didn't solve it (went into Format, Cells, Number and selected 0 decimal places). Does anyone know how to fix this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent the cell from changing the number I enter?
OR Format the cells/column as text. Right clickFormat cellsSelect
Text...before entering the number... -- If this post helps click Yes --------------- Jacob Skaria "Littlestar29" wrote: Everytime I enter a number (18 digits) into the cell it changes it to a different number. I've tried changing the number format in the formatting menu and that didn't solve it (went into Format, Cells, Number and selected 0 decimal places). Does anyone know how to fix this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent the cell from changing the number I enter?
Excel has only 15 digits of precision.
After 15 digits it will replace with zeros. See other replies for workarounds. Gord Dibben MS Excel MVP On Fri, 26 Jun 2009 07:26:02 -0700, Littlestar29 wrote: Everytime I enter a number (18 digits) into the cell it changes it to a different number. I've tried changing the number format in the formatting menu and that didn't solve it (went into Format, Cells, Number and selected 0 decimal places). Does anyone know how to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
how do i enter date and time in cell without it changing | New Users to Excel | |||
how do i enter date and time in cell without it changing | Excel Worksheet Functions | |||
How to prevent users from changing cell format | Excel Discussion (Misc queries) | |||
how do I prevent a RAND number from changing | Excel Worksheet Functions |