Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
retain value and delete format
Hello:
I would like to know how to retain the value thats in a cell but delete the formatting of the cell. Below is a column of numbers that represent response times (in seconds). I've used special paste to retain the values and reformat the values to number or general (under formatting), but to no avail. I want to see what response times exceed our 8min 59sec (or 539 seconds). To do this I wrote a logic statement, in a seperate column, to mark those times that meet and/or exceed our response times. The logic statement is IF(A2<=539, 1(true), 2(false)). when I copy the formula down the column all I get is 1(true); even for the values that are obviously false. Not to be out done, in a seperate column I typed in a few of the values and tried my logic statement again and it work. I have over 50,000 lines of data and I can't type all the values in. What else can I do to retain the number value in a cell and yet delete the formatting of the cell. Again I've tried special paste. This is what my column of values look like: Response time(sec) 245 476 345 39 244 139 162 355 311 155 368 266 898 209 Thank in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete/change the formula of a cell and yet retain its cont | Excel Worksheet Functions | |||
Retain date format in cell | Excel Discussion (Misc queries) | |||
Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
How delete formula bar and retain the computed number in a cell? | Excel Worksheet Functions | |||
Retain text format from a WORD document | New Users to Excel |