AJ California
New Member
- Joined
- Jun 27, 2012
- Messages
- 1
Appreciate any assistance in streamlining a current process I find myself needing to complete frequently down hundreds of rows of data.
Here is what I am now doing:
1.) Finding a percentage.
2.) Copying and Pasting the percentage found as the number value and format.
3.) Applying the Fixed command to set decimal place to two or four.
4.) Copying and Pasting the Fixed result as the number value and format.
5.) Choosing to convert to numbers.
6.) Formatting as number or percentage
Thanks for any tips or tricks - Alan
Here is what I am now doing:
1.) Finding a percentage.
2.) Copying and Pasting the percentage found as the number value and format.
3.) Applying the Fixed command to set decimal place to two or four.
4.) Copying and Pasting the Fixed result as the number value and format.
5.) Choosing to convert to numbers.
6.) Formatting as number or percentage
Thanks for any tips or tricks - Alan