Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change formula into value exel cells
I have exported details from sage program to exel and I can see all
information (names.numbers) in exel sheet, but actualy there is only formulas in the cells and then I try to copy information I get only hieroglyphs, how can I change thouse formulas into values ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change formula into value exel cells
To copy the entire worksheet, click the box at the top left-hand corner of
the worksheet, where the column and row labels intersect. This will select the entire worksheet. The copy, paste special and select "values" in the pop-up. You can use the mouse by right clicking with the mouse somewhere in the worksheet cells. I find some reports downloaded from another program have hidden rows and/or columns. If this is true in your case and you want to easily unhide the rows and columns, while the entire worksheet is selected, press "CTRL (" and "CTRL )" "Viktoras" wrote: I have exported details from sage program to exel and I can see all information (names.numbers) in exel sheet, but actualy there is only formulas in the cells and then I try to copy information I get only hieroglyphs, how can I change thouse formulas into values ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bulk change cells to Array Formula | Excel Discussion (Misc queries) | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
how to change a formula for a large group of cells | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) |