ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel changing my numbers (https://www.excelbanter.com/excel-discussion-misc-queries/161475-excel-changing-my-numbers.html)

Liela

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


Kevin B

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


David Biddulph[_2_]

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




Liela

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


David Biddulph[_2_]

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





All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com