Mike formulated the question :
On Sep 26, 1:40*pm, GS wrote:
GS made a typo: The apostrophe converts numeric to text. A CSV file is a
TEXT file and so
* Excel should handle the apostrophe appropriately.
--
Garry
Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Garry,
But I need the table to stay in csv, but the Algebraic modeler
complains about record CW above of that table!?
Record CW is not numeric text and so any mathematical equation would
have a problem with it if it's not a variable that contains a value. I
doubt the problem lies with the apostrophe; -more like your Algebraic
modeler doesn't have a way to handle non-numeric text. (IOW, no data
validation methodology)
Is the Algebraic modeler a program OR an Excel macro?
Is your data in an 'Excel Table'? OR Are you just calling the 'block'
of data in the worksheet a table?
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc