Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
When I paste a credit card number into Excel spreadsheet, it either changes
it to a formula (like 4.22242223242452+15) or rounds the last two digits UP. I've tried ALL the number formats, and it still happens. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
Format the cells as Text.
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
Number can only be 15 digits long. Large numbers are usually shown in
scientific format when using General format. If you want the number to show you will need to format it as text before you enter the number, or precede your number with an apostrephe like so '1234567890123456 (NOTE: The apostrophe won't show) "nohotin" wrote: When I paste a credit card number into Excel spreadsheet, it either changes it to a formula (like 4.22242223242452+15) or rounds the last two digits UP. I've tried ALL the number formats, and it still happens. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
No. That doesn't work. It won't take 16 digit numbers without either changing
them to a formula or altering the last digit to a 0. "Dave O" wrote: Format the cells as Text. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
That means I have to retype the number. Can I change the number of digits to
16? "Sloth" wrote: Number can only be 15 digits long. Large numbers are usually shown in scientific format when using General format. If you want the number to show you will need to format it as text before you enter the number, or precede your number with an apostrephe like so '1234567890123456 (NOTE: The apostrophe won't show) "nohotin" wrote: When I paste a credit card number into Excel spreadsheet, it either changes it to a formula (like 4.22242223242452+15) or rounds the last two digits UP. I've tried ALL the number formats, and it still happens. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
No you can't
-- Regards, Peo Sjoblom "nohotin" wrote in message ... That means I have to retype the number. Can I change the number of digits to 16? "Sloth" wrote: Number can only be 15 digits long. Large numbers are usually shown in scientific format when using General format. If you want the number to show you will need to format it as text before you enter the number, or precede your number with an apostrephe like so '1234567890123456 (NOTE: The apostrophe won't show) "nohotin" wrote: When I paste a credit card number into Excel spreadsheet, it either changes it to a formula (like 4.22242223242452+15) or rounds the last two digits UP. I've tried ALL the number formats, and it still happens. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
Did you follow Dave O's suggestion? If you Format|Cells... Number tab,
select the Text format, it will accept your credit card number as entered without any loss of precision. Kostis Vezerides |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
I think what the OP meant was if he/she could change the format on already
entered truncated numbers, it also looks as he/she pastes info as well -- Regards, Peo Sjoblom "vezerid" wrote in message oups.com... Did you follow Dave O's suggestion? If you Format|Cells... Number tab, select the Text format, it will accept your credit card number as entered without any loss of precision. Kostis Vezerides |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number changes to formula
When you insert numbers that have more than 15 digits, you permanently lose
any digits beyond the 15th (I don't think it rounds, it simply turns them into 0's). You have no choice but to retype the number if you didn't format the cell as text beforehand or use an apostrophe to begin with. Also, if you are copy and pasting information, you might need to paste special and select values. Sometimes when you paste a number it will paste the number format as well. "nohotin" wrote: That means I have to retype the number. Can I change the number of digits to 16? "Sloth" wrote: Number can only be 15 digits long. Large numbers are usually shown in scientific format when using General format. If you want the number to show you will need to format it as text before you enter the number, or precede your number with an apostrephe like so '1234567890123456 (NOTE: The apostrophe won't show) "nohotin" wrote: When I paste a credit card number into Excel spreadsheet, it either changes it to a formula (like 4.22242223242452+15) or rounds the last two digits UP. I've tried ALL the number formats, and it still happens. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
2nd attempt ~ complicated formula | Excel Worksheet Functions | |||
Transform a Cell from Formula to Number | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) |