Format Cell option Is not able to change Format of Cell

Discuss the spreadsheet application

Format Cell option Is not able to change Format of Cell

Postby rajeev631007 » Thu Dec 18, 2008 1:26 pm

HI,

We are facing issue with Format Cell. If We are copy Numeric value from one cell to other cell and we want to change that numeric value into text through format cell. it is not converting this numeric value into text through format cell option. for this same scenario excel give tip option on the same cell to convert numeric value to text or vice verse convert text to numeric value. Is there any such option in open office version 3. Please help me out in this issue.

Regards,

Rajeev Gautam
OOo 3.0.X on Ms Windows XP + Vista
rajeev631007
 
Posts: 1
Joined: Thu Dec 18, 2008 1:25 pm

Re: Format Cell option Is not able to change Format of Cell

Postby acknak » Thu Dec 18, 2008 6:53 pm

I don't know about Excel, but as far as Calc goes, changing a cell's format will never change the data in the cell. If a cell holds a numeric value and you change the cell format to text, it does not convert the number to text. That seems like the right approach to me, and I'm a little surprised that Excel would actually change the data in the same situation.

If you want to change a numeric value to text, you have to do something that "re-enters" the data as text.

One way to do a whole column of numbers is this:
1) Select the column
2) Apply the text format
3) Data > Text to Columns; OK

If you need to do a range of cells spanning several columns, use this:
1) Select the cells
2) Apply the text format
3) Edit > Find & Replace
Search for: .*
Replace with: &
Options/Regular expressions: YES
Options/Current selection only: YES
Click "Replace All"
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 28 guests