Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel puts a 0 at the end of my number
I am putting large number into a cell, why does Excel changing my last number
to a zero? Is there a way to leave it the way I want it? |
#2
|
|||
|
|||
Excel puts a 0 at the end of my number
On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors"
wrote: I am putting large number into a cell, why does Excel changing my last number to a zero? Is there a way to leave it the way I want it? By a large number, I guess you mean one containing 15 digits. You need to format the cell as text. You won't of course be able to do any arithmetic with it. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
|
|||
|
|||
Excel puts a 0 at the end of my number
Thank you for the quick response.
I did try this and it is still rounding my number. I don't need to calculate it, but I do need that last number to display. I put the number in quotes, and than ran a right and left function. This got the number...is there another way? "Richard Buttrey" wrote: On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors" wrote: I am putting large number into a cell, why does Excel changing my last number to a zero? Is there a way to leave it the way I want it? By a large number, I guess you mean one containing 15 digits. You need to format the cell as text. You won't of course be able to do any arithmetic with it. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
|
|||
|
|||
Excel puts a 0 at the end of my number
Precede the number with an apostrophe ('). The apostrophe will
not show in the cell, but will display in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dan Connors" wrote in message ... Thank you for the quick response. I did try this and it is still rounding my number. I don't need to calculate it, but I do need that last number to display. I put the number in quotes, and than ran a right and left function. This got the number...is there another way? "Richard Buttrey" wrote: On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors" wrote: I am putting large number into a cell, why does Excel changing my last number to a zero? Is there a way to leave it the way I want it? By a large number, I guess you mean one containing 15 digits. You need to format the cell as text. You won't of course be able to do any arithmetic with it. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#5
|
|||
|
|||
Excel puts a 0 at the end of my number
Great!!!
Thanks "Chip Pearson" wrote: Precede the number with an apostrophe ('). The apostrophe will not show in the cell, but will display in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dan Connors" wrote in message ... Thank you for the quick response. I did try this and it is still rounding my number. I don't need to calculate it, but I do need that last number to display. I put the number in quotes, and than ran a right and left function. This got the number...is there another way? "Richard Buttrey" wrote: On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors" wrote: I am putting large number into a cell, why does Excel changing my last number to a zero? Is there a way to leave it the way I want it? By a large number, I guess you mean one containing 15 digits. You need to format the cell as text. You won't of course be able to do any arithmetic with it. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
Excel random number | Excel Discussion (Misc queries) | |||
Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) |