Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you stop excel from editing your cell?
I type in "$1,819,000,000,000" and it always turns into,"1,819,000,000,000"
How do you stop it? I type in "$4,422,200,000,000" and it alwasys turns into,"$4,422,200,000,000.00" Excel edits almost any thing I type!! How can I stop this? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you stop excel from editing your cell?
If you want the cell contents to stay *exactly* as you type them in,
you can either pre-format the cell to text (i.e. Format | Cells | Number (tab) and select Text from the list) or type an apostrophe in front of the rest of the input. The apostrophe will not be visible in the cell, though you can see it in the formula bar. Note that in both cases the cell will contain text values, so you will not be able to carry out any arithmetic on them. Hope this helps. Pete First-timer at Excel wrote: I type in "$1,819,000,000,000" and it always turns into,"1,819,000,000,000" How do you stop it? I type in "$4,422,200,000,000" and it alwasys turns into,"$4,422,200,000,000.00" Excel edits almost any thing I type!! How can I stop this? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you stop excel from editing your cell?
First-timer at Excel wrote:
I type in "$1,819,000,000,000" and it always turns into,"1,819,000,000,000" How do you stop it? I type in "$4,422,200,000,000" and it alwasys turns into,"$4,422,200,000,000.00" Excel edits almost any thing I type!! How can I stop this? Try this right click format cell currency and set decimal places to zero. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I stop an excel cell being calculated | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) |