J
Julia Easter
Hi I have a column in Excel that needs to be converted as
follows, I think I can do this using "Format" - "Cells" -
"Custom Number" but am not sure what to type in so it
keeps the first character as text followed by 5 digits
(adding a zero to the end)
Account number:-
A4578
B6789
C6892
E8900
The account numbers need to become 6 digit (zero at the
end) but retain the starting letter
HELP!
Ta
Julia
follows, I think I can do this using "Format" - "Cells" -
"Custom Number" but am not sure what to type in so it
keeps the first character as text followed by 5 digits
(adding a zero to the end)
Account number:-
A4578
B6789
C6892
E8900
The account numbers need to become 6 digit (zero at the
end) but retain the starting letter
HELP!
Ta
Julia