Formatting numbers in each cell after I have calculated their valu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make numbers in each cell after I have calculated their value
with a formula. Currently I have to calculate the value and then re-type all
of the numbers so I can use them in another spreadsheet.
 
Yikes! Too much work!


Try this:
Select the range of formulas
From the Excel main menu:
<edit><copy>
<edit><paste special>
Check: Values
Press [Enter]
Press [ESCAPE]....to cancel copy/paste mode

Or....using keyboard shortcuts (after selecting the cells)
[Ctrl]+C
[Alt] E S V [Enter] [Escape]

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
You must log in or register to reply here.

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

Similar Threads

Scrabble Value calculation for Welsh words 0
Calculate After hours 3
Error: Value in Formula of wrong data type 0
Excel formula, sum the value cell and if empty cell left blank 0
Calculate row/column number in reference formula 2
cell value functioning as whole number in formulas 4
I would like to change numbers in a cell automatically 1
Cell =Now() << Can I get this to auto-update? 2

Back
Top