Thread: Excel vs .csv?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Excel vs .csv?

Mike used his keyboard to write :
Hi everyone,

1) Why ' on the LHS of a number is used in Excel table? What does it
do?

'3
'23
'34
'CW
.
.


2) What do you do if that table is saved as .csv file then?

I am using an Algebraic modeler that would take #1 but complains about
#2!

Thanks,
Mike


The apostrophe converts numeric to text. A CSV file is a TEXT file and
so Excel should handle the apostrophe approriately.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc