Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2014, 08:58 AM
Catalin.B Catalin.B is offline Data entry asistance needed Windows Vista Data entry asistance needed Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default


Hi Fireman,
You already have a great answer from mr. Graham Mayor, but i suggest an alternative solution using a very simple Custom Format:
Select column A for example, if this is your column with this code format, go to ribbon's Home tab, Numbers section, choose custom format, and place this custom format in Type section: "BC102014"#
Note that this custom format will only work with numbers, if you type text in that column, the prefix code will not be added. This means that you will be able to use the exact number you typed. If you type 11234 in a cell, after you press enter, the prefix will be added; when you select the cell, even if it will show BC10201411234, if you look in the formula bar, the cell contains only what you typed: 11234...
Cheers,
Catalin Bombea
Attached Files
File Type: xlsx Book1.xlsx (7.7 KB, 11 views)
Reply With Quote
  #2  
Old 09-06-2014, 05:48 AM
fireman0174 fireman0174 is offline Data entry asistance needed Mac OS X Data entry asistance needed Microsoft Office 2008 for Mac
Novice
Data entry asistance needed
 
Join Date: Aug 2010
Posts: 8
fireman0174 is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
Hi Fireman,
You already have a great answer from mr. Graham Mayor, but i suggest an alternative solution using a very simple Custom Format:
Select column A for example, if this is your column with this code format, go to ribbon's Home tab, Numbers section, choose custom format, and place this custom format in Type section: "BC102014"#
Note that this custom format will only work with numbers, if you type text in that column, the prefix code will not be added. This means that you will be able to use the exact number you typed. If you type 11234 in a cell, after you press enter, the prefix will be added; when you select the cell, even if it will show BC10201411234, if you look in the formula bar, the cell contains only what you typed: 11234...
Cheers,
Catalin Bombea
Only glitch is that any entry that starts with a zero (0), for example 00123, does not add the zeroes.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data entry asistance needed Automatic Entry fjdesjardins Word 1 08-18-2014 05:07 PM
Data entry asistance needed ON ENTRY Command la_gillespie25 Word VBA 1 05-15-2013 02:18 AM
How to create a Main category mirrored in Sub category data entry type of solution? Geza59 Excel 0 10-19-2012 05:44 AM
example of radio buttons in for data entry? derohanes Excel 1 03-05-2011 09:37 AM
Printable Entry Form eJames Excel 1 01-07-2010 09:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft