Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changing my numbers
I have a spreadsheet with a string of numbers in one column, once the numbers
get past a certain point they will either do (4.11248E+15) this or they will round to the nearest number. It is imperative that I have these numbers exactly the way that I put them in. Can someone help me asap??? Thanks!! Liela |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changing my numbers
The numbers are so large they're displayed in scientific notation. You can
format the column as a text format and the numbers will be treated as text, or if you prefer you can use an apostrophe prefix to convert the numeric value to a text string ala Lotus 1-2-3. -- Kevin Backmann "Liela" wrote: I have a spreadsheet with a string of numbers in one column, once the numbers get past a certain point they will either do (4.11248E+15) this or they will round to the nearest number. It is imperative that I have these numbers exactly the way that I put them in. Can someone help me asap??? Thanks!! Liela |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changing my numbers
Put them in as text. For numbers, Excel is limited to 15 significant
figures. -- David Biddulph "Liela" wrote in message ... I have a spreadsheet with a string of numbers in one column, once the numbers get past a certain point they will either do (4.11248E+15) this or they will round to the nearest number. It is imperative that I have these numbers exactly the way that I put them in. Can someone help me asap??? Thanks!! Liela |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changing my numbers
Problem is that when I format it as text it rounds the last number. Any
other ideas? Not sure how to covert the numeric value to a text string ala Lotus 1-2-3. "Kevin B" wrote: The numbers are so large they're displayed in scientific notation. You can format the column as a text format and the numbers will be treated as text, or if you prefer you can use an apostrophe prefix to convert the numeric value to a text string ala Lotus 1-2-3. -- Kevin Backmann "Liela" wrote: I have a spreadsheet with a string of numbers in one column, once the numbers get past a certain point they will either do (4.11248E+15) this or they will round to the nearest number. It is imperative that I have these numbers exactly the way that I put them in. Can someone help me asap??? Thanks!! Liela |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changing my numbers
You have to format the cells as text *before* you put the data into the
cell. As Kevin told you, you can convert the numeric value to a text string as you type it in by preceding it with an apostrophe. -- David Biddulph "Liela" wrote in message ... Problem is that when I format it as text it rounds the last number. Any other ideas? Not sure how to covert the numeric value to a text string ala Lotus 1-2-3. "Kevin B" wrote: The numbers are so large they're displayed in scientific notation. You can format the column as a text format and the numbers will be treated as text, or if you prefer you can use an apostrophe prefix to convert the numeric value to a text string ala Lotus 1-2-3. -- Kevin Backmann "Liela" wrote: I have a spreadsheet with a string of numbers in one column, once the numbers get past a certain point they will either do (4.11248E+15) this or they will round to the nearest number. It is imperative that I have these numbers exactly the way that I put them in. Can someone help me asap??? Thanks!! Liela |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent excel from automatically changing my numbers? | Excel Discussion (Misc queries) | |||
changing numbers into a barcode using excel | Excel Worksheet Functions | |||
Changing Numbers in Excel | Excel Discussion (Misc queries) | |||
Excel Changing Numbers Automatically | Excel Discussion (Misc queries) | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions |