Hello everyone. This should be an easy one for many of you, although I thought it would be easy for me as well.
I have a number of excel spread sheets whereby the data in one of the columns should be following a certain format, yet doesn't due to the way a third party entered the information. I need to make the data consistent before I can use the data for comparison against other spreadsheets and access tables.
What I encounter is data such as:
05-12345
When I require it to be:
GY-05-12345
In the same column, there is data with this format already, just not most of the data.
I tried selecting one cell as well as many cells to modify them to a custom format. I used 'help' and made a custom format of:
"GY-" 0
But this did nothing, although I could undo the changes that didn't appear to have happened.
I also tried:
"GY- " 0
"GY-"0
"GY- "0
Yet nothing happened.
What am I missing?
Thanks for any help you can spare me.
Jay
I have a number of excel spread sheets whereby the data in one of the columns should be following a certain format, yet doesn't due to the way a third party entered the information. I need to make the data consistent before I can use the data for comparison against other spreadsheets and access tables.
What I encounter is data such as:
05-12345
When I require it to be:
GY-05-12345
In the same column, there is data with this format already, just not most of the data.
I tried selecting one cell as well as many cells to modify them to a custom format. I used 'help' and made a custom format of:
"GY-" 0
But this did nothing, although I could undo the changes that didn't appear to have happened.
I also tried:
"GY- " 0
"GY-"0
"GY- "0
Yet nothing happened.
What am I missing?
Thanks for any help you can spare me.
Jay