Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you convert an entire column into absolute value?
x.x
please help ;.; |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you convert an entire column into absolute value?
Say your data in in column A. In an un-used (helper) column enter:
=ABS(A1) and copy down Then copy the helper column and paste/special as value back into column A -- Gary's Student "Lorraine" wrote: x.x please help ;.; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |