Question about Computers & Internet

2 Answers

Excel 2007: number formatting

I would like to convert all numbers to style# format, which has letters on the front and the back.

so it is like AB#####CD.

How do I create this built-in number system?

thanks,
genny

Posted by on

  • Anonymous Mar 05, 2008

    yes

×

2 Answers

Thanks for the answer.

Based on your solution, I need to create an actual program to add thesse letters to make plan numbers to style numbers.
What program is it, and how do I creat it, then?

thank you!
genny

Posted on Feb 09, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 108 Answers

Genny....

Let me give you some basic info first. Information within a cell is discreet. You can add to it...the $ sign as an example...with functions (actual code which equals a program) embedded in Excel or you can type it in.....but you would have to create an actual program to do what you would like to do.

I don't use your version of Excel but I am extremely confident you cannot do what you would like to do. Sorry....Tango.

Posted on Feb 09, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I'm used to using Excel 2007. I bought a new


Select the column. Click Format, click cell, click number, select the date format you want, click OK. Done.

Sep 04, 2011 | Microsoft Computers & Internet

Tip

How to convert older Office documents to Office 2007 format


<span> <p><span>The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office. They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows. The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.</span><br /> <p><img src="compatibility-model-excel.jpg" /> <span>Follow these steps to convert older Office documents to Office 2007 format:</span><br /> <span>Open the Word document which you want to convert into Word 2007 format</span><br /> <span></span> <br /> <span></span> <br /> <br /> <span>Click on the Microsoft Office button on the top left.</span><br /> <span>Click on Convert on the left hand side of the menu.</span><br /> <img src="convert-excel.jpg" /> <p><span>Click on the OK button on the Microsoft Word Office dialog box which appears. </span><br /> <p><img src="corverting-documents.jpg" /> <p><span>By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.</span><span> </span><br /> <p><img src="show-compatibility.jpg" /></span> <p><span><span> google_protectAndRun("ads_core.google_render_ad", google_handleError, google_render_ad); </span></span><br /> <p><b> </b><br />

on Dec 12, 2010 | Computers & Internet

Tip

How to convert older Office documents to Office 2007 format


The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office. They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows. The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.
google_protectAndRun("render_ads.js::google_render_ad", google_handleError, google_render_ad);
compatibility-model-excel.jpg Follow these steps to convert older Office documents to Office 2007 format:
Open the Word document which you want to convert into Word 2007 format.
Click on the Microsoft Office button on the top left.
Click on Convert on the left hand side of the menu.
convert-excel.jpg Click on the OK button on the Microsoft Word Office dialog box which appears.
corverting-documents.jpg By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.
show-compatibility.jpg

on Sep 03, 2010 | Computers & Internet

2 Answers

How to convert excel 2007 to 2003


With Excel 2007, open the spreadsheet.
Click File
Click Save As
Choose to save the file in the "Excel 2003" format.
Choose a filename.
Click Save.

Aug 19, 2010 | ScanSoft PDF Converter Professional...

3 Answers

Export tally data to excel


tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Aug 27, 2009 | Tally T2245 Matrix Printer

1 Answer

Excel Charts in PPT 2003 and 2007 not working correctly


Have you tried uninstalling the beta, and possibly uninstalling and reinstalling your copy of Office 2003?

Jan 26, 2009 | Microsoft Excel for PC

1 Answer

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

7 Answers

Pptx file converter for office 2007 to office 2003


I am looking for office 2003 2007 converter for using with a word doc

Jul 25, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Forgot password to open Excel sheet


If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Excel 2007 spreadsheets


The most likely problem is that you (or somebody) has R1C1 reference style turned on.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.

Jan 10, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...