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:

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

2 Answers

In my PC Office 2003 is installed. Now sometimes I received Word & Excell 2007 files which is not opening in my PC. Can you tell me without installing Office 2007 how can I convert those docx and xlsx...


You don't have to convert the .docX or .xlsX to view in MS Office 2003, just install the "Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats" and you should be able to open files, created or saved as the MS Office 2007 format.

If you need to edit the files you can too, but you will saved it in the MS Office 2003 formats.

Hope it helps.

Feb 18, 2011 | Computers & Internet

1 Answer

Hi, I am trying to change an excel spreadsheet. There are unit numbers on the spreadsheet which have converted themseles to dates ie 4/52 has now become Apr-52. I have tried everythiong to change it but...


Right-click the cells and go to 'Format Cells'. Then, select the correct format. If you're wanting to leave the slash (/) in the number, you'll probably have to make it a text format.

Dec 22, 2010 | Microsoft Computers & Internet

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

I want to transfer my data saved in microsoft excel 2007 to microsoft excel 2003


hi

just open your Excel 2007 data in 2007 from the just save as 2003 all date will save in 2003 format

Sep 03, 2010 | Microsoft Computers & Internet

1 Answer

I currently have microsoft office professional 2007 trial version which has expired. If I don't want to order it and just go back to my 2003 version can I just cancel the 2007 version? Will it just convert...


If you still have the installation CD for Microsoft Office 2003 and the key that goes with it, you can un-install the Trial version of Office 2007 and install Office 2003. Files saved Office 2007 format are not redable with Office 2003.

To preserve your files (the ones made with Office 2007) you must go through the following procedure:
  1. Open each file with the application that created it (Word, Excel, Powepoint, or what have you)
  2. If it its a Word 2007 file save it in Word2003 format
  3. If it is an Excel 2007 file save it in the Excel 2003 format.
  4. Etc.
This is only necessary if you intend to modify them at some later time.
If you only want to read (not modify) them you can still do that because Microsoft offers a free Word viewers.

Other free software you can use to open files created with Office 2007 is OpenOffice.org 3. You might lose some formatting but the files will be accessible to you.


Jun 21, 2010 | Computers & Internet

1 Answer

Is it possible for a spreadsheet application like Microsoft Excel, To consistently skip specific number entries?


Not likely. Check for formatting, especially cell formats. For example...If you have set a number format to only digits to the left of the decimal point, decimals less than 1.0 will not appear... .12345 will appear as 0.000.

Nov 13, 2009 | Microsoft Windows XP Professional

2 Answers

My self rakesh,using 2007 microsoft word,how to convert the 2007 word format to 2003 format


Convert a document to Office Word 2007 The Word Convert command clears the compatibility options so that the document layout appears as it would if it had been created in Word 2007.
  1. Click the Microsoft Office Button default.aspx?assetid=za100771021033, and then click Convert.
  2. In the Microsoft Office Word dialog box, click OK.
  3. Do one of the following:
    • To replace the original file with a file in the Office Word 2007 file format, click the Microsoft Office Buttondefault.aspx?assetid=za100771021033, and then click Save.
    • To save the original document in its original file format and create another document in the Office Word 2007 file format, click the Microsoft Office Button, click Save As, and then type a new name for the file.
    Note If the original .doc file is saved in a location other than your local drive, Word keeps the original .doc file and creates a new .docx file when you click Convert.
:)

Mar 14, 2009 | Microsoft Windows Vista Ultimate Edition

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

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

98829 Answers

David Payne
David Payne

Level 3 Expert

14071 Answers

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

Answer questions

Manuals & User Guides

Loading...