Problem with cell Formatting

O

Om Prakash

Hi all,
I am facing a problem that is cell formatting.. I am using owc
spreadsheet. I am loading xml data into Spreadsheet.
I have some data like 11, 12, 13 it is automatically converted to date like
11/12/2013 and 11, 12 to dec/11
What could be the problem there.
When i am changing the cell numberformat to General then it is
automatically converted to some number like
11, 12, 13 ---> 41590. I want to display the data as it is.

If you have solution then please reply me back as soon as possible

Om Prakash
 
J

Josh Sale

If you're trying to put 11, 12, 13 all into one cell, try prefacing it with
a single quote (').

josh
 
O

Om Prakash

Hi thanks for reply,
but what you suggest is a temproray solution, I what i need is, I want to
ddispaly my record as it is
the addtional things are not meaningful.
Can i disable automatic formating of OWC Spreadsheed Component

Om Prakash
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top