I need to format a cell so that it will always display the account code directly when managers are entering information into their requisition form. Our account format needs to be:
4444.4444.22.22
I guess dots or dashes wouldn't necessarily matter. I have tried some formats, but I don't get the results I am hoping for.
It just needs to be 4 digits, dot, 4 digits, dot, 2 digits, 2 digits.
Any suggestions? Thank you!
Last edited by karstens; 01-14-2011 at 04:16 PM.
Go to Custom Formatting and type in
000"."000"."00 00
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for the help.
That did not quite work, but it was a great help.
This modification did work:
0000"."0000"."00"."00
Needed to add addition 0 to the first two sets. Also, there needed to be another "." on the last two, and a space removed.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks