text format doesn't work properly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

When I change a bunch of numbers to text format it doesn't work straight
away. I need to edit each number (F2) to kick in the change and then the
format seems to stick. I'm using Excel 2003.

When I used IsText function it said false until I edited each cell and
pressed enter.

I'm having to do this for each cell. Please help.

Any help greatly appreciated.

Thanks

Suzanne
 
| Hi,
|
| When I change a bunch of numbers to text format it doesn't work straight
| away. I need to edit each number (F2) to kick in the change and then the
| format seems to stick. I'm using Excel 2003.
|
| When I used IsText function it said false until I edited each cell and
| pressed enter.
|
| I'm having to do this for each cell. Please help.
|
| Any help greatly appreciated.
|
| Thanks
|
| Suzanne
 
Hi Suzanne,

Use a formula =TEXT(A1,"general") and copy down as far as needed. Copy and paste Special Values over the original numbers.
Test on a copy first!


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| When I change a bunch of numbers to text format it doesn't work straight
| away. I need to edit each number (F2) to kick in the change and then the
| format seems to stick. I'm using Excel 2003.
|
| When I used IsText function it said false until I edited each cell and
| pressed enter.
|
| I'm having to do this for each cell. Please help.
|
| Any help greatly appreciated.
|
| Thanks
|
| Suzanne
 
Select the column with your numbers in it, click Data/TextToColumns on
Excel's menu bar, click the Next button twice to get you to Step 3 of 3
(see title bar), then select Text from the "Column data format" section and
press the Finish button.

Rick
 
Works great
Tx
S

Rick Rothstein (MVP - VB) said:
Select the column with your numbers in it, click Data/TextToColumns on
Excel's menu bar, click the Next button twice to get you to Step 3 of 3
(see title bar), then select Text from the "Column data format" section and
press the Finish button.

Rick
Click to expand...
 
Back
Top