Format Problem

  • Thread starter Thread starter manikandan
  • Start date Start date
M

manikandan

Hi
how can i save an excel file to text file with out
chainging the format.

ie
Excel file:
adf 12
a 1

when i change this to text file the alighment changes like
adf 12
a 1

so how can i solve this problem. i tryied many wayes and
nothing work out properly.

so if someone know this , plzz do help me.
manikandan
 
Try saving it as a "Formatted Text (Space delimited) (*.prn)" file.

You may have to widen columns to make it look right. (And I like to change the
font to Courier New--a nice non-proportional font. Then I can see how it'll
line up.)
 
Back
Top