| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to % using only custom number format challenge | Excel Discussion (Misc queries) | |||
| Convert text number to number formate | Excel Discussion (Misc queries) | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Linear Mode
