software

Hello,
I have a cell value formatted as Accounting 0000000000 (10 places). How can
I convert this formatted value to an actual text value? Example: A1 is
actually 2525, but appears as 0000002525. I want to have B1 have an actual
text value of '0000002525.

Thank you!
Terri

See if this works for you:
format the cells as Text

Formatgt;Cellsgt;Number tab
Category: TEXT

Then, anything you type into those cells will be treated as text.

Does that help?

***********
Regards,
Ronquot;Terriquot; wrote:

gt; Hello,
gt; I have a cell value formatted as Accounting 0000000000 (10 places). How can
gt; I convert this formatted value to an actual text value? Example: A1 is
gt; actually 2525, but appears as 0000002525. I want to have B1 have an actual
gt; text value of '0000002525.
gt;
gt; Thank you!
gt; Terri

I'm sorry....my fault for not clarifying.

The cell contents will still be 2525...formatting won't change that.
But, here's something to try:
A1: 2525
B1: =TEXT(A1,quot;0000000000quot;)

Then Copy B1
Select A1
Editgt;Paste Specialgt;Values

Does that help?

***********
Regards,
Ronquot;Terriquot; wrote:

gt; Ron,
gt; Formatting as text didn't change the actual cell content. The formula bar
gt; still displays the 2525 and not the '0000002525. Any other suggestions?
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; See if this works for you:
gt; gt; format the cells as Text
gt; gt;
gt; gt; Formatgt;Cellsgt;Number tab
gt; gt; Category: TEXT
gt; gt;
gt; gt; Then, anything you type into those cells will be treated as text.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt;
gt; gt; quot;Terriquot; wrote:
gt; gt;
gt; gt; gt; Hello,
gt; gt; gt; I have a cell value formatted as Accounting 0000000000 (10 places). How can
gt; gt; gt; I convert this formatted value to an actual text value? Example: A1 is
gt; gt; gt; actually 2525, but appears as 0000002525. I want to have B1 have an actual
gt; gt; gt; text value of '0000002525.
gt; gt; gt;
gt; gt; gt; Thank you!
gt; gt; gt; Terri

Ron,
Formatting as text didn't change the actual cell content. The formula bar
still displays the 2525 and not the '0000002525. Any other suggestions?

quot;Ron Coderrequot; wrote:

gt; See if this works for you:
gt; format the cells as Text
gt;
gt; Formatgt;Cellsgt;Number tab
gt; Category: TEXT
gt;
gt; Then, anything you type into those cells will be treated as text.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;Terriquot; wrote:
gt;
gt; gt; Hello,
gt; gt; I have a cell value formatted as Accounting 0000000000 (10 places). How can
gt; gt; I convert this formatted value to an actual text value? Example: A1 is
gt; gt; actually 2525, but appears as 0000002525. I want to have B1 have an actual
gt; gt; text value of '0000002525.
gt; gt;
gt; gt; Thank you!
gt; gt; Terri

Yes, your formula works great! Thanks a million!

quot;Ron Coderrequot; wrote:

gt; I'm sorry....my fault for not clarifying.
gt;
gt; The cell contents will still be 2525...formatting won't change that.
gt; But, here's something to try:
gt; A1: 2525
gt; B1: =TEXT(A1,quot;0000000000quot;)
gt;
gt; Then Copy B1
gt; Select A1
gt; Editgt;Paste Specialgt;Values
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;Terriquot; wrote:
gt;
gt; gt; Ron,
gt; gt; Formatting as text didn't change the actual cell content. The formula bar
gt; gt; still displays the 2525 and not the '0000002525. Any other suggestions?
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; See if this works for you:
gt; gt; gt; format the cells as Text
gt; gt; gt;
gt; gt; gt; Formatgt;Cellsgt;Number tab
gt; gt; gt; Category: TEXT
gt; gt; gt;
gt; gt; gt; Then, anything you type into those cells will be treated as text.
gt; gt; gt;
gt; gt; gt; Does that help?
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Terriquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hello,
gt; gt; gt; gt; I have a cell value formatted as Accounting 0000000000 (10 places). How can
gt; gt; gt; gt; I convert this formatted value to an actual text value? Example: A1 is
gt; gt; gt; gt; actually 2525, but appears as 0000002525. I want to have B1 have an actual
gt; gt; gt; gt; text value of '0000002525.
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you!
gt; gt; gt; gt; Terri