Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2012

[Date Index] [Thread Index] [Author Index]

Search the Archive

How to export to Excel numbers as text fields?

  • To: mathgroup at smc.vnet.net
  • Subject: [mg127085] How to export to Excel numbers as text fields?
  • From: "Alexey Popkov" <lehin.p at gmail.com>
  • Date: Fri, 29 Jun 2012 04:50:13 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com

Hello,
I have a list containing telephone numbers in the form "+74951234567" and I 
wish to export it to Excel without quotes preserving original appearance 
with the plus sign. In Excel I can set the cell format to "Text" and then 
entering +74951234567 without quotes will not result in converting it to 
number. Is it possible to force Export in Mathematica to create Text cells?

Thanks in advance.

Alexey





  • Prev by Date: Export/Save as text + plots/images
  • Next by Date: Book
  • Previous by thread: Re: Export/Save as text + plots/images
  • Next by thread: Book