travelingwilly
New Member
- Joined
- Jun 19, 2002
- Messages
- 24
Hello folks
I wish to create a flat file with Formulas so that excel translates properly. I know that if I put =("00001") it will be be translated in the spreadsheet as 00001 instead of automaticly thinking it is a number and converting to a number 1 . But I am sure you can do the same thing with formulas....
example of csv
=("00001"),34,34,21,=formula(r[1]c[-3]+r[1]c[-3])
=("00002"),34,34,21,=formula(r[1]c[-3]+r[1]c[-3])
=("00003"),34,34,21,=formula(r[1]c[-3]+r[1]c[-3])
,,,,=sum(r[1]c[1]:r[3]c[1])
Or somthing like that. Is there away to this.
Basicly I want the formula to be used not the value so when it is loaded I can change a value and I will see the change without adjusting the sheet...
Make sense ???
I wish to create a flat file with Formulas so that excel translates properly. I know that if I put =("00001") it will be be translated in the spreadsheet as 00001 instead of automaticly thinking it is a number and converting to a number 1 . But I am sure you can do the same thing with formulas....
example of csv
=("00001"),34,34,21,=formula(r[1]c[-3]+r[1]c[-3])
=("00002"),34,34,21,=formula(r[1]c[-3]+r[1]c[-3])
=("00003"),34,34,21,=formula(r[1]c[-3]+r[1]c[-3])
,,,,=sum(r[1]c[1]:r[3]c[1])
Or somthing like that. Is there away to this.
Basicly I want the formula to be used not the value so when it is loaded I can change a value and I will see the change without adjusting the sheet...
Make sense ???