Home |
Search |
Today's Posts |
#1
|
|||
|
|||
my formatting changes do nothing to the data
I used SSN formatting for cells and nothing happened to the data in one
column, but when is used the same formatting for another column of data, the data immediately changed to the SSN format. Why? |
#2
|
|||
|
|||
If the SSN is stored as real numbers, then the number format will work nicely.
If the SSN was entered as text, then the number format won't change it. You may have to reformat the cell as General (or some number) and then reenter the value (without the dashes). Alex wrote: I used SSN formatting for cells and nothing happened to the data in one column, but when is used the same formatting for another column of data, the data immediately changed to the SSN format. Why? -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave.
"Dave Peterson" wrote: If the SSN is stored as real numbers, then the number format will work nicely. If the SSN was entered as text, then the number format won't change it. You may have to reformat the cell as General (or some number) and then reenter the value (without the dashes). Alex wrote: I used SSN formatting for cells and nothing happened to the data in one column, but when is used the same formatting for another column of data, the data immediately changed to the SSN format. Why? -- Dave Peterson |
#4
|
|||
|
|||
On Sat, 16 Jul 2005 16:03:03 -0700, "Alex"
wrote: I used SSN formatting for cells and nothing happened to the data in one column, but when is used the same formatting for another column of data, the data immediately changed to the SSN format. Why? An even quicker solution is to select the column, click Data -- Text to Columns, check Fixed Width and hit Finished. The conversion to numeric values (if they were text) will continue to use the format you'd previously applied (i.e. SSN formatting) so you save a step by not having to go back and change it to SSN formatting again. -- "Learning is a behavior that results from consequences." B.F. Skinner |
#5
|
|||
|
|||
Mangus,
It worked!!!! Thanks a lot. I'm importing the results of an AS/400 query into Excel, editing the format, then merging that data into form letters. It's been a challenge, but I think I've got it thanks to folks like you and Dave. |
#6
|
|||
|
|||
On Sat, 16 Jul 2005 18:00:01 -0700, "Alex"
wrote: Mangus, It worked!!!! Thanks a lot. I'm importing the results of an AS/400 query into Excel, editing the format, then merging that data into form letters. It's been a challenge, but I think I've got it thanks to folks like you and Dave. Good deal! Enjoy the rest of your weekend- Mangus- -- "Learning is a behavior that results from consequences." B.F. Skinner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Formatting data | Excel Discussion (Misc queries) | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Formatting a worksheet for data entry | Excel Worksheet Functions |