Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Stop Auto Format To Scientific Notation


I run a macro that imports a table from web page:

[url]

I import only the table with no formatting.

Excel tries to be helpful, and formats some of the cells in scientific notation.

I have tried to format the column to the "Text" format prior to the import with

Columns(2).NumberFormat = "@"

This does not work. If you import the table you can see that rows 1405, 1406, 1407, 1408 all have the same scientific notation value. Their true values should be 0E0, 0E4, 0E8, 0E9 respectively.

There are quite a few other instances in the column when a text value has "E" for the second character that Excel will format on its own.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Stop Scientific Format For Large Numbers
Im importing figures into column G of my worksheet, and I need a code so it automatically adds a "0" to the start of each row in column G plus format it.

For example, im pasting in 970702090341 but its showing as 9.70702E+11.

Once I format the cell to 'number' and 0 decimal places it looks fine, but want to save the hassle of doing it each time. Plus I need a zero at the start.

Is there a code possible for this?

View Replies!   View Related
Automatically Formatted As Scientific Notation
I'm trying to filter a long list to look for specific employee numbers. The employee numbers are so long that they have to be formatted as text or they are automatically formatted as scientific notation (they are 18 digits long). For some reason this is causing the filter not to work properly.

Employee ID
006010000000000661
006015000000000082
006015000000000319
006015000000000319
006015000000000552
006010000000000370
006010000000000370
006015000000000921
006010000000000503
006015000000000835
006015000000000834
006015000000000689
006010000000000391
006010000000000391
006010000000000030
006010000000000030
006015000000000718
006015000000000202
006015000000000202
006015000000000202
006010000000000585
006015000000000712

View Replies!   View Related
Disable Scientific Notation - Permanently, How
AHH Scientific notation is annoying me, I don't want to see auction #'s in scientific notation. How can I disable the feature in excel 2007?

View Replies!   View Related
Data Converted To Scientific Notation
I work for a company that exports data from a website into Excel.

So here's my problem:

The data is usually Part Numbers using numbers and letters. When a Part Number is, for example, 248E12 we have this reaccurring issue. Importing it into Excel automatically converts it to scientific notation (ie. 248E+12 or 2.48E+14 to be exact). "Format Cell" doesn't convert it back because it was auto-converted when "exported". I need a way of fixing this problem without going line by line and doing the math to convert it myself.

I don't have time for that. Some of my files have thousands of lines.

View Replies!   View Related
Stop/Prevent Web Query Auto Formatting
I use a query table to import data into a workbook which works fine

With wsActiveSheet.QueryTables.Add(Connection:=sQueryString, _
Destination:=wsActiveSheet. Range("A1"))
.Name = CStr("main.html?LANG=de&search=true&searchterm=" & sIdentifier & "_1")
.PreserveFormatting = True
.BackgroundQuery = False
.RefreshStyle = xlInsertEntireRows 'xlInsertDeleteCells
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebTables = "9,14"
.WebPreFormattedTextToColumns = True
.WebSingleBlockTextImport = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With

One of the fields I import has a value like 100:01 or 10:01 or 01:01 or other combinations (the above ones are the most frequent ones).
Unfortunately excel always converts this field into a date and a time but this is not what I want.
Is there any way to stop excel doing this? I tried to work around it with the text property e.g. formating it to text after I imported the data and formating the entire sheet to use text before


View Replies!   View Related
Stop Now Function Auto Updating When New Row Added
I have fought with this for 2 days and I am trying to have a worksheet cell update the date and time if the cell it is referencing (B3 see below)

Here is the formula I am using however it updates every time a new row is added to the worksheet. So the Date/Time stamp on each row is always updated to NOW() everytime.

=IF(ISNA(B3),"0/0/00 00:00",NOW())

I would like to have a Date/Time stamp stay as is once that row has been added. Is there anyway to stop the field from updating once the date and time have been set?

View Replies!   View Related
Stop European Date Format Changing
I have a userform which is used to update a spreadsheet.

There are 7 textboxes which add dates to the spreadsheet. These dates are then used in formulas.

Every time a record is saved the date format changes.

Ths means that if the date is entered dd/mm/yyyy it writes mm/dd/yyyy and this is fine. When this record is next retrieved it will show mm/dd/yyyy and any new date will be dd/mm/yyyy.

Wen saved to the spreadsheet both formats change meaning the dates in the spreadsheet appear in diffrent formats messing up all formulas.

How can I stop the date format changing each time the record is saved?

View Replies!   View Related
Format Method - Stop A Cell Turning Into A Date?
Right, sorry this is probably a simple one but I can't do it... I have information in a variable that is "1-4" the variable is defined as a String but whenever I use the following code excel turns it into a date.

View Replies!   View Related
How Do You Stop Changing The Date Format During Find And Replace?
When I remove "Release date:" from "Release date:24 December 2008," excel will automatically change the text to "24-Dec-08." Yes, I did try to format the column to "text" before using find and replace.

This wouldn't be a problem, except that half the dates are in Dutch, so only half the dates are changed, which means that I can't make all date formats in a column uniform.

View Replies!   View Related
Conditional Format Shading Stop Updating Until Save...?
I have a sheet that highlight cells to show that they need to still be filled out if another cell in the same row has a number in it. What happens is that when you put the number in the row the cells won't become shaded or partially shade until the workbook is saved.. Maybe I can put some code in that tells the work book to update whenever a cell is changed?

View Replies!   View Related
Scientific Data: Timestamp
I am attempting to enter Timestamp data from a movie in this format:

minute:second.millisecond

When I enter a frame timestamp of 18 minutes, 42 seconds, and 5 milliseconds, excel auto formats this data to 12:18:43AM.

This is not what I want. I have attempted multiple types of cell formats in an attempt to enter this data without auto formatting. One requirement for the format is the ability to subtract two of the times for a change in time measurement. I have tried every setting under the "Time" format list, as well as custom formats, which fail to subtract.

View Replies!   View Related
Auto Format Image
I've got a simple macro for asking a user to locate a file of choice and inserting it into specific cell.

Is there a way I can code it so that regardless of the image it 'fits to fill' the cell? The images may vary

The size of the cell will be fixed, but I don;t know who to ascertain that information or tell VBA what it is?

Sub InsertLogo()
Range("A1:E5").Select 'merged cell'
Application.Dialogs(xlDialogInsertPicture).Show
'Object.AutoSize = True
End Sub

I tried using the 'Object.AutoSize = True, but kept getting stumped on a run time error.

View Replies!   View Related
Auto-format - 2003
I am pasting output from SAS into a spreadsheet. The data I am pasting cannot be put into columns beforehand. When I do text-to-columns, the data are auto-formatted. This is how it looks before text-to-columns:

159 xx Char 2 2. $2. xx


This is how it is auto-formatted:

159xxChar22$2.00 xx

The loss of the period [2 to 2.] and the addition of zeros [$2. to $2.00] is a disaster because it makes my SAS code non-functional. Is there anyway to stop auto-formatting in text-to-columns? Is there a more user-friendly software besides Excel that would be better to use?

View Replies!   View Related
RC Notation
I dont know why this wont work
it falls over on the ".Columns(6).FormulaR1C1=" line

View Replies!   View Related
Auto Filter - Data Format
I am having trouble with using the auto filter, and I suspect it is due to my data format.

I am importing data from an outside source (I have no control on how the data is output). The data in the column I am concerned with contains various formats, such as numbers, letters, and a combo of the two. e.g.:

12345
sample
sam123ple

I have been taking the entire column and formatting it as text to make all of the data consistent. The problem I see comes when I go to use the autofilter, to say custom>begins with "123". The value 12345 does not show up in my filter. However, if I double click the cell 12345, then hit enter, and re-run my autofilter, it shows up.

Does anyone know the reason why this double-click-enter method forces Excel to recognize the value? And is there a way to mass-produce this command for the entire data set? Right now, I'm up to 5000 lines of data, so to do this on each would take a while.

View Replies!   View Related
Auto Format To Uppercase Or Propercase
I am trying to make a column of names appear in upper case (the first letter). I know about Upper(). I cant put that formula in this column because the names are typed there, (it would erase formula). How can I do this as well as have them alphabetically ordered?

View Replies!   View Related
Auto Fill Custom Format Numbers
I have the following list of numbers

0000 0000 0000 0000 0000 0100
0000 0000 0000 0000 0000 0101
0000 0000 0000 0000 0000 0102

and I need to continue the list to

0000 0000 0000 0000 0000 0326

I tried dragging by the grip in the bottom right hand corner but it changes the first didit only. I tried to put it the numbers in the format

100
101
102

and using a custom format number to put in the extra zeros. This worked fine until I used a countif (or it may of been a lookup) statement in my code to look for 0000 0000 0000 0000 0000 0100 and it can't find it as the number is 100. Is there away around this that will save me typing in an awful lot of zeros.

View Replies!   View Related
Convert Formula To RC Notation
I have got a list of formulae in column A e.g.

'=SUM(E14:E24)
'=SUM(E14:I14)
'=SUM(J14:N14)
'=SUM(Q14:Q24)
'=SUM(V14:V24)
(formulae is stored as text, i.e. preceeding with an ')

and i am looking for a VBA macro to cycle through the list and give the relative notation in column B i.e.

'=SUM(R[-11]C:R[-1]C)
'=SUM(RC[-12]:RC[-8])
'=SUM(RC[-8]:RC[-4])
'=SUM(R[-11]C:R[-1]C)
'=SUM(R[-11]C:R[-1]C)



View Replies!   View Related
Meaning Of Bracket Notation
The following code was posted in another thread:

Private Sub UserForm_Initialize()
Dim a, v, x, ws As Worksheet
Set ws = Sheets("Scheduled Courses")
a = ws. Range("a2", ws.[a65536].End(xlUp)).Value
With CreateObject("scripting.dictionary")
For Each v In a
If Not IsEmpty(v) And Not .exists(v) Then
.Add v, Nothing
End If
Next
x = .keys
End With
With Me.ComboBox1
.Clear ' clear the listbox content
.List = x
.ListIndex = 0 ' select the first item
End With
End Sub

How are the brackets used in the 4th line? I have not seen this notation before. Is this some kind of a shorthand for a Range("A65536") reference?

View Replies!   View Related
Auto Format Fill Colour Background On Certain Cells
I have been working on a spreadsheet but I use autoformat for.

For example if the date in the cell matches today's date then it turns the text read and makes it bold.

I was wondering if there was a way to format several cells in a row if a certain criteria was met.

for example

A B C
1 Item Cost Quantity
2 Car 11,520 2
3 Bike 7,500 1
4 Tyres 50 4

Now for example if I set a condition whereas the quatity is greater than 3 then it would highlight the whole row.

So in the example above I would like to to highlight row 4 and Fill colour cells A4,B4 & C4 with a yellow background and Red Text and make the texted bold.

View Replies!   View Related
Referring To Range() Using Shortcut Notation
I have noticed in many of the Excel help files that the developers liked to use shortcut notation for Range reference in VBA.

For example, Range("A1:B10") would be [A1:B10].

I was doing a bit of testing with this, and was not able to make the shortcut notation work with a variable. Does the shortcut method have the capabilities to do the equivalent of Range("A1:B" & LR)?

If it does have that capability, is it just due to force of habit that we always use Range() to refer to ranges, or would there be a more in-depth reason.

View Replies!   View Related
Square Brackets - Vba Notation
I often see square brackets around ranges in code. eg [A1]

if there are any advantages/disadvantages with using this notation, apart from the obvious its shorter?

View Replies!   View Related
Auto-populating Starting Times From 1 Format To The Other -VBA Required
If you look at schedule.jpg you will see a how our work schedules are formatted.

Then if you look at schedule2.jpg, you will see what I wish to convert it to.

Now I'm looking for a way to search by the name of our employee (2 seperate sheets) and then by the time which corresponds to the first "1" in the chart under that name and the last "1" in the chart under that name.

So once I fill out our schedule.jpg, it will auto-populate the times on schedule2.jpg.

Is this even possible?

If necessary, I will be able to put both schedule and schedule 2 on one sheet.

On schedule.jpg time starts at 7:00 - Column C
and ends at 8:00 - Column AC

View Replies!   View Related
Auto Format Some Merged Cells Within A Sheet Based On The Information In Them
I am trying to auto format some merged cells within a sheet based on the information in them. how to reference the information within theses cells?

View Replies!   View Related
Notation Of Formula With Range (small Question)
Ok, I want to use a dynamic range in my Vlookup formula.

I want to use this formula: ....

View Replies!   View Related
Selecting A Range Of Cells With R1C1 Notation
I'm trying to select a range of cells using the R1C1 notation. But I'm making an error in the syntax. I know it's really simple, I just don't know what's wrong.

View Replies!   View Related
Code Converting Text To Exponential Notation
I have a bit of code that is grabbing only the first 9 positions of an alpha-numeric string. The problem I am running into is that when the alpha-numberic value contains an "E", the code turns it into an exponential number in error.

For example, I have the following in column G: 01877E107000. When I run the code, it turns into an alpha-numeric value. The result should be 01877E107 (in column K). I tried using the text function within the code.

View Replies!   View Related
Date Notation: Dates A Represented As A Number On Screen
In a sheet the first collum is defined as a date field. However the dates a represented as a number on screen. How can I change the way it's showed on screen?


View Replies!   View Related
Stop Macro: Button To Hit Or Better Just Some Keys To Hit To Stop It Without Using The Ctrl+alt+del Which Closes Everything
my excel sheet runs through a lot of calculations, opens Flowmaster, a simulations program, passes on data, receivs data and so on. Is there any way to have a user input to stop the whole simulation. During the first tries I had a lot of break point in my debugger. But now I want to have a button to hit or better just some keys to hit to stop it without using the ctrl+alt+del which closes everything.

View Replies!   View Related
Banker's Rounding Or Scientific Rounding
I am trying to round similar to Banker's Rounding or Scientific Rounding but I can't find a consistent formula that works perfect with decimals.

Using three decimal places for all the samples, I can get 0.0785 to round to 0.078 but 0.1785 wants to round to 0.179 instead of staying 0.078. Or 0.0005 will round to 0 but 0.5115 wants to round to 0.511 instead of 0.512.

Here is a list of sample numbers along with desired results:
.0785 should be .078
.5115 should be .512
.5035 should be .504
.0005 should be 0
.0025 should be .002
.0194 should be .019
.0195 should be .02
.0135 should be .014
.0115 should be .012
.8115 should be .812

I cannot find a formula which gives me all of these results. Here is a list of the formulas I have tried so far (NOTE: cell A2 is the working cell in my worksheet where I enter the number to be rounded)

1) =MROUND(A2,0.001)

3) =ROUND(A2,3)

4) =IF(ISERROR(IF(MOD(MID(A2,4,1),2)=1,CEILING(A2,0.001),FLOOR(A2,0.001))),0,IF(MOD(MID(A2,4,1),2)=1,CEILING(A2,0.001),FLOO R(A2,0.001)))

5) =EVEN(A2)

6) =ROUNDUP(A2,3)

7) =ROUNDDOWN(A2,3)

View Replies!   View Related
Prevent From Converting Non-number To Scientific Number
I am importing a list of values from a text file. Some of the values have the letter "E" embedded in the string. For example one of the imported values is "29875E100". Excel is automatically converting this into scentific notation. Is there a way to avoid this?

View Replies!   View Related
Macro To Format The Auto-Sum Row Without Knowing What Row# It Will Be
I currently have a macro setup that puts Auto-Sum data in the row below the bottom-most row of data. What code would I need to format this Auto-Sum row with the following parameters automatically...

1. Merge & center F & G in the Auto-Sum row with the text "Totals".
2. Change the row height of the Auto-Sum row to 44 pixels.
3. Center the vertical alignment of the Auto-Sum row.
4. Put the thickest border around the Auto-Sum row in cells A-K.

View Replies!   View Related
Auto Format Spreadsheet With Various Rows Month To Month
I have a database that I export to excel every month. The export process is built in the database software (ACT!2009). The export opens Excel with the standard Book1.xls file name. All the field columns will be the same every month.

Goal:
I need to format the spreadsheet to make it more readable and have been assigned the task of:
1 - Inserting a blank row between each row that contains data and filling in with color.
2 - Resizing the blank row to make it look like a "thick" border.
3 - Auto adjusting the columns to correct size.
4 - The last column contains comments and needs to be wrapped text.
5 - All of this needs to fit on 1 sheet (landscape).

Issues:
1 - Each month there will be a different number of rows.
2 - I know I can create a macro to do this but the macro that I would be creating will be in a saved template or spreadsheet. How could I use a that recorded macro in a spreadsheet that is called Book1.xls?

I have attached 2 spreadsheets. One called Book1.xls which is the raw data after exported and the 2nd spreadsheet called Formatted which is the end result that I am looking for.

View Replies!   View Related
Air Force Mission Tracker-Auto Counting & Auto Copying
Making a mission tracker that requires less upkeep than my units previous methods. I am using Excel 2007 and have some things in mind that I would like it to do.
On the down side, I have only basic experience with excel and have never used macros or VBA.
Even if what I am after could be solved with functions (which I prefer), I simply do not quite know how to make what I want without assistance. Ok, now on to the description.

The mission tracker aside from showing a list of the missions we have done during our program, it needs to also generate metrics automatically. In my worksheet, I am using columns A-G and rows 1-501.

The mission scheduling type in Column E are listed below. The letters on the left are what I am using in the sheet, the part to the right is what it really means:

Column D has the day of the week listed as: Mon, Tues, Wed, Thurs, Fri, Sat, Sun.

now the metrics I need to be generated are the number of different types of each mission compared, how many of each type of mission was flown per day of the week, how many of each type of mission was flown per month.

Basically what I need is a way to automatically count the number of rows that meet a specific criteria throughout the range. This would require being able to check the value/text of multiple cells at a time and count the number of rows that meet that criteria.

[SOLVED] 1. The first part would be to have the worksheet be able to count the number of each type of the 9 mission scheduling codes throughout the range. I would be storing the count in new cells that would then be connected to pie charts.

[SOLVED] 2. The second part would be to count the number of each type of mission that was flown per day of the week. That would require searching both mission type and day of the week. All I would need is a working formula for 1 set, then I could switch mission codes and weekdays to match all the 63 possible outcomes.

3. Knowing the number of each type of mission flown per month. This would be checking the date and the mission type. The trickier part that comes up in my mind is that our programs span multiple calendar years, so it would have to track it by month and year, that way there is a difference between Jan 2009 and Jan 2010. The counted numbers would be used to make histograms. It would be nice if the chart titles could be automatic based on the dates inputed in the mission tracker. If I needed to choose a maximum time length for it to cover, I would pick 3 years.

4. I would like to figure out how to make an inputted line of data on the main tracker sheet to create a copy in the corresponding worksheets based on schedule type, that way a person could look at/print a specific type without having to sort the main list.

The actual goal is to make it where a person can enter the 1 line of data per mission (cells A-G) and the mission metrics update automatically after each mission is inputed allowing upper level supervision to have current information quickly whenever it is needed. Currently we need about a weeks lead time to get the information asked for on our current progress.

View Replies!   View Related
Auto Complete And Auto Delete With Data Validation
Within a data validation selection, are you able to do both Auto Complete and Auto Delete? I have this posted at another forum [url]but have not been able to find a solution (a copy of the file, test. zip is there as well). I am not sure it is possible, or, at least I have been unable to get it working. I can do each, but not both.

I have also been utilizing:

[url]

[url]

View Replies!   View Related
Userform Date Format Reverting Back To Us Format On Change Event
I have created a userform but I am having extensive problems with the date formats.

My system is set to UK and short date is set to: DD/MM/YYYY

When I used code to add the values in the userform to the spreadsheet, any that contained a date format would revert to the US format.

So I finally figured out to use DateValue to format it correctly for example: ...

View Replies!   View Related
Save Conditional Format Colour But Delete Condition Format
I have a Sheet ( Named "Summary" for Example ) of about 4,000 Rows that has a LOT of Conditional Formatting.

I Added Another 100 Rows this Morning and when I Tried Saving it a Message Saying that Not All the Formatting for the New Data that had Been Added had Been Saved. Is there a Macro or Something I can Run that will Make the Conditionally Formatted Cells Stay the Colour that they are but Delete the Conditional Formatting Part of it Achieved Using "Format" & "Conditional Format" from the Menu Please.

Ideally I would like to be Able to Enter the Number of Rows ( From Row ? to Row ? ) that I want this to Apply to.

View Replies!   View Related
Change Cell Format Based On Existing Currency Format
I would like to have a single button that changes a range of cells from the USD to EURO to perhaps CAD symbol. Can this operation be performed, such that if I start in dollars, and I click the button once, it shifts by range to EURO (not formulas...just symbol)...and then if I click the same button again, it goes to CAD, and then back to USD with a third click?

View Replies!   View Related
Time Format: Format Cells To Contain Minutes, Seconds And Hundredths
How can I format cells to contain Minutes, Seconds and Hundredths of seconds to be used in calculations eg 1.24.99 means 1 minute and 24.99 seconds. Example calculation is: 1.24.99 - 1.24.90 =0.0.09

View Replies!   View Related
Save Number As Text In Txt Format Wo Changing The Format
In order to export an excel table into another program I first need to save the excel file as .txt. The .txt file can then be imported by the other program.

First I however need to make excel understand that the value should be a text and not a value. I therefore format the number as text (0000150235) by adding "0000150235". After saving the file as .txt the format changes from "0000150235" to """0000150235""". I do however need the format in the .txt file to be "0000150235". Can anyone tell me how I can save "0000150235" as .txt and get the value "0000150235" in the .txt file.

View Replies!   View Related
Format Climatic Data From A Weather Station Into A Desired Format
I need to format some climatic data from a weather station into a desired format. There are a lot of cut&paste and transposing involved. I think it will be easy but tedious for anyone trained in VB to write a macro but unfortunately I am not. I've tried recording a macro but it turns out that it is not general enough to deal with all the spreadsheets that I've got.

I've attached a spreadsheet which shows the original format (in sheet 1) and the desired format (in sheet 2). To briefly describe, I only need the temperature data for 8am and 2pm, the rest of the information in sheet 1 is useless to me.

View Replies!   View Related
Vlookup Function: Re-format The Information Into A Horizontal Format By Week
I have a forecast which is sorted by product code by week vertically. I need to create a lookup to re-format this information into a horizontal format by week. I have started this by transposing the information as my attachment shows but I am hoping there is a lookup formula which will be easier and quicker. I have attached the actual document and the data I want to sort is Sheet 2. I have started in Sheet 1. I want to look up the code in column A, then lookup the week number which would be B2 in Sheet 1 and return the value of that Code in that week from Sheet 1.

View Replies!   View Related
Format Email Generated By Sheet To Have An HTML Format
I'm trying to format my email generated of excel sheet to have an HTML formal before they are sent out using MS Outlook.

I have googled, searched your forums and also tried to figure out a solution with the existing helps on the internet. I need help on how to format emails genarated out of my excel sheet. I know a bit of HTML syntax but a newbie to VBA. I'm guessing the formatting has to be done in the Emailbody text function in my code.

I'm also trying to understand the logic behind the code and also learning excel vba bit by bit at the minute.

View Replies!   View Related
Change A Date In Text Format Into Regular Format
I have an excel sheet full of dates in text format and want to convert them into regular format. For instance, one of the dates listed is in text as "60801". I'd like it to show in regular date format of mm/dd/yyyy, so that 60801 becomes 8/1/2006.


View Replies!   View Related
VBA: Format Amts Into Text $ 9.99 Type Format
Need to create a set of aligned text amts from various cells...Tried Format but unable to get right combination...I've looked at many threads and most seem related to getting amt from text instead of reverse.

Cell may contain nothing or a monetary amt, negative or positive. Output needs to be in format of "$9,999.99-" or similar...with leading zeros suppressed but a min of "$ 0.00" showing, so that above/below amts with be decimal point aligned in a fixed font situation.

I've almost gotten my routine finsihed but this is last remaining obstacle.

View Replies!   View Related
Pasted European Date Format Coverting To US Format
I have a problem where i am just trying to do a simple copy of dates from one spreadsheet to another

18/03/2008 00:00 however when the its copied to the other spreassheet is changes to the US date formate 3/18/2008 0:00 I need to keep the format as date as the date needs to be the current day. How do i get this to remain UK

View Replies!   View Related
Format Cell: Changing The Format Of Sheet2 To Exactly Like The Following Image Below
I need in changing the format of sheet2 to exactly like the following image below.
*there are some codes in sheet2 which I think is the place to change the format.

View Replies!   View Related
A1 Format Vs R1C1 Format & Portability
I have a scenario where my VBA code checks the value of a cell, and then depending on the value the address of another cell is stored. I then setup some conditional formatting, and had been using that stored address as a reference.

View Replies!   View Related
Convert Text Format To Numbers Format In Vb
how i convert text format into numbers format in vb.
Currently

i have a formula in vB:

Private Sub Textbox3_Change()
Textbox3 = Val(Textbox1.Value) + Val(Textbox2.Value)
End Sub

however..when i sum it up (in excel) using"=sum" formula...it ooes not sum up

I faced an error "number stored as text"..how to i convert it to numbers format in vb.

View Replies!   View Related
Format Number To Text With Specific Format
I'll get straight to the point: How can I change this text format from 474556788 to 0-47455678-8 (dash added after 0 and before the last number). I need to apply this to around 5000 rows (can't do that manualy). I want it to be int his format:

474556788 to 047-455678-8

Tks Auto Merged Post;474556788 to 047-455678-8 (This is the wanted format)

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved