View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default convert sum number to a set number

Select the small square between the A and the 1. Ctrl+C, Alt+E, S, V, Enter.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

I have a spreadsheet full of formulas and I need to convert each formulated
cell to a single set number. (non-formulated number)