Help with application of custom format to entire column

G

Guest

Help !!

When I'm using the format cells - number tab - categorie "custom" function
to an entire column; I enter format codes (####-#####-#) then select OK
button.
The existing data (1234567891)(no dashes) does not appear in each cell
within the column; not until I edit each cell (F2 or double-click) and hit
enter does the format appear. How do I make the format appear without going
to each individual cell?
 
D

Dave Peterson

I think your data is actually text. And just changing the format of the cell
won't change the value of the cell.

One way to change Text Numbers to Number Numbers is...

Select an empty cell
edit|copy
select the offending range
edit|paste special|click Add.

You may have to reformat that range to your custom format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatted to place dashes within numbers formatted as text 1
For Joey2004 et al. From OP: Re Appending Question 3
Forcing the display of new custom formatting 3
Date Formating Problem 1
date format will not change in Excel 3
Adding an apostrophe to a column of numbers 6
Column Date Format 1
Date Format Not Responding to MM/DD/YY 2

Top