Hi,
I have a list of id's stored as general. The id's are usually like this 1810042740 and I have used the Format cell and Custom to make them look like this '1810042740', To do this I have put '0000000000', in Custom.
Some of the id's are different - they are stored as general but look like this 181004AAA0 and then my custom '0000000000', doesn't work. How can I use Custom and make them look like this '181004AAA9',
Best regards, drū_lilja
Try 0000000000 without the ' worked OK for me, if I'm replicating what you have correctly
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
welcome to the forum. does this help?
'0000000000';;;'@'
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you very much for your reply
It's nearly there. I only need the , in the end of the id. With your formula it looks like this '181004AAA9' but I need to have comma in the end '181004AAA9', can you help me with that?
didn't realize comma was part of your format. perhaps:
'0000000000',;;;'@',
Hi - no but I found out that this works : '0000000000';;;'@'","
Thank you again for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks