oblix
Board Regular
- Joined
- Mar 29, 2017
- Messages
- 183
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
I have a sheet that has formulas linking to other sheet cells
example of one cell: ='Sheet 1'!G18
would like to change all formulas on a specified sheet to a text formula like example below:
=TEXT('Sheet 1'!G18,"$0.00")
there are just to many to change every single formula to a text formula
is this possible with vba code?
example of one cell: ='Sheet 1'!G18
would like to change all formulas on a specified sheet to a text formula like example below:
=TEXT('Sheet 1'!G18,"$0.00")
there are just to many to change every single formula to a text formula
is this possible with vba code?