how to change formula into value exel cells

G

Guest

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 ?
 
G

Guest

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
)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top