ExcelBanter - convert sum number to a set number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - convert sum number to a set number (https://www.excelbanter.com/excel-worksheet-functions/246766-convert-sum-number-set-number.html)

John

convert sum number to a set number

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

ryguy7272

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)

[email protected]

convert sum number to a set number

On Tuesday, October 27, 2009 5:26:01 PM UTC-4, ryguy7272 wrote:
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)

This worked perfectly, thank you!!

All times are GMT +1. The time now is 01:15 PM.