Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The cell
Hi,
I have a column that is dedicated to mac addresses. Some are letters and numbers and some are just numbers (16 chars). I want the cell to leave the input values as they are and not format them in any way. Here's the problem I have. I know why it is doing this, but I want to show the numbers exactly as I input them. When I type 16 chars of numbers only, the look changes to this: 1.24865E+15 from this: 1248651497265430 i don't want to have to format every cell that has a numbers only because i never know which cell that will be. I just want it to be general across the board but it changes it for number values. Is there any way of setting excel to leave the input values as they are and not reformat them? Thanks. |
#2
|
|||
|
|||
Excel has only 15 digit precision, precede the entry with an apostrophe to
make it text Regards, Peo Sjoblom "Angelo" wrote: Hi, I have a column that is dedicated to mac addresses. Some are letters and numbers and some are just numbers (16 chars). I want the cell to leave the input values as they are and not format them in any way. Here's the problem I have. I know why it is doing this, but I want to show the numbers exactly as I input them. When I type 16 chars of numbers only, the look changes to this: 1.24865E+15 from this: 1248651497265430 i don't want to have to format every cell that has a numbers only because i never know which cell that will be. I just want it to be general across the board but it changes it for number values. Is there any way of setting excel to leave the input values as they are and not reformat them? Thanks. |
#3
|
|||
|
|||
Thanks for the rely. It actually reformats the cell on 12
digits as well (not 11 and below). Also, it changes the last number to a zero if I format the cell as 'number'. e.g. 1000000000000012 will change to 1000000000000010 with a formatted number. I suppose this makes perfect sense since the number is so great but I don't want it to reformat the way it looks. I'd rather have all those digits. Very odd... -----Original Message----- Excel has only 15 digit precision, precede the entry with an apostrophe to make it text Regards, Peo Sjoblom "Angelo" wrote: Hi, I have a column that is dedicated to mac addresses. Some are letters and numbers and some are just numbers (16 chars). I want the cell to leave the input values as they are and not format them in any way. Here's the problem I have. I know why it is doing this, but I want to show the numbers exactly as I input them. When I type 16 chars of numbers only, the look changes to this: 1.24865E+15 from this: 1248651497265430 i don't want to have to format every cell that has a numbers only because i never know which cell that will be. I just want it to be general across the board but it changes it for number values. Is there any way of setting excel to leave the input values as they are and not reformat them? Thanks. . |
#4
|
|||
|
|||
Have you tried typing the apostrophe before entering your digits as the
first responder suggested? Excel cannot handle all the digits in a 16-digit number as Excel only has 15-digit accuracy. Excel can indeed handle large numbers but the accuracy in the final digits will suffer, as you have seen. You need to leave the entry as text, not convert it to a number. If you really need to calculate with all 16 digits of your numbers you will need some other application. Bill wrote in message ... Thanks for the rely. It actually reformats the cell on 12 digits as well (not 11 and below). Also, it changes the last number to a zero if I format the cell as 'number'. e.g. 1000000000000012 will change to 1000000000000010 with a formatted number. I suppose this makes perfect sense since the number is so great but I don't want it to reformat the way it looks. I'd rather have all those digits. Very odd... -----Original Message----- Excel has only 15 digit precision, precede the entry with an apostrophe to make it text Regards, Peo Sjoblom "Angelo" wrote: Hi, I have a column that is dedicated to mac addresses. Some are letters and numbers and some are just numbers (16 chars). I want the cell to leave the input values as they are and not format them in any way. Here's the problem I have. I know why it is doing this, but I want to show the numbers exactly as I input them. When I type 16 chars of numbers only, the look changes to this: 1.24865E+15 from this: 1248651497265430 i don't want to have to format every cell that has a numbers only because i never know which cell that will be. I just want it to be general across the board but it changes it for number values. Is there any way of setting excel to leave the input values as they are and not reformat them? Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |