Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers changing
I'm having a problem with typeing number into a cell. I'm trying to put the
number 270073037038 and it is putting 2.70073E+11, infact every number I'm putting in is showing that same number. The weird thing is, they all will go to the correct hyperlink, or if you click on it the correct number shows. What can I do to correct it? I'm using Excel 2007. Thanks, Heidi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers changing
Try giving those cells a different number format.
Select the cells Format|cells|Number tab|Number (with 0 decimal places???) You may have to widen the column to see the value. Justme-in-Az wrote: I'm having a problem with typeing number into a cell. I'm trying to put the number 270073037038 and it is putting 2.70073E+11, infact every number I'm putting in is showing that same number. The weird thing is, they all will go to the correct hyperlink, or if you click on it the correct number shows. What can I do to correct it? I'm using Excel 2007. Thanks, Heidi -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers changing
Thank you so much! I was changing the format last night but I never thought
to do the 0 decimal place! "Dave Peterson" wrote: Try giving those cells a different number format. Select the cells Format|cells|Number tab|Number (with 0 decimal places???) You may have to widen the column to see the value. Justme-in-Az wrote: I'm having a problem with typeing number into a cell. I'm trying to put the number 270073037038 and it is putting 2.70073E+11, infact every number I'm putting in is showing that same number. The weird thing is, they all will go to the correct hyperlink, or if you click on it the correct number shows. What can I do to correct it? I'm using Excel 2007. Thanks, Heidi -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Text to Numbers | Excel Discussion (Misc queries) | |||
changing numbers on x axis | Excel Discussion (Misc queries) | |||
Mistake of changing decimal into whole numbers | Excel Discussion (Misc queries) | |||
Way To Copy Formula In Column Without Changing All Cell Numbers | Excel Discussion (Misc queries) | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions |