retain formatting as an actual value
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
FormatCellsNumber 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
|