retain formatting as an actual value

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

Format>Cells>Number tab
Category: TEXT

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

Does that help?

***********
Regards,
Ron


"Terri" wrote:

> 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

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,"0000000000")

Then Copy B1
Select A1
Edit>Paste Special>Values

Does that help?

***********
Regards,
Ron


"Terri" wrote:

> 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?
>
> "Ron Coderre" wrote:
>
> > See if this works for you:
> > format the cells as Text
> >
> > Format>Cells>Number tab
> > Category: TEXT
> >
> > Then, anything you type into those cells will be treated as text.
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> >
> > "Terri" wrote:
> >
> > > 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

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?

"Ron Coderre" wrote:

> See if this works for you:
> format the cells as Text
>
> Format>Cells>Number tab
> Category: TEXT
>
> Then, anything you type into those cells will be treated as text.
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "Terri" wrote:
>
> > 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

Yes, your formula works great! Thanks a million!

"Ron Coderre" wrote:

> 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,"0000000000")
>
> Then Copy B1
> Select A1
> Edit>Paste Special>Values
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "Terri" wrote:
>
> > 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?
> >
> > "Ron Coderre" wrote:
> >
> > > See if this works for you:
> > > format the cells as Text
> > >
> > > Format>Cells>Number tab
> > > Category: TEXT
> > >
> > > Then, anything you type into those cells will be treated as text.
> > >
> > > Does that help?
> > >
> > > ***********
> > > Regards,
> > > Ron
> > >
> > >
> > > "Terri" wrote:
> > >
> > > > 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