Change Format From Number To Text.
i have several fields in the database that the format is number. then, i have a report page that allow user to open it the ms excel. my problem is, when all data transfered to ms excel, all data that is in number format, they are located at the right of the cells and there is 1 data named noIC, suppose this data is a 12 digits number but in the ms excel, it became something like this 780945+E12....
to solve this problem, i have to change the cell's format everytime all data have been transferred to ms excel. i have to set to left indent for all fields that contain numbers and for the noIC i have to set from General to Number.
View Replies
ADVERTISEMENT
I have virtual directory where I run test.asp page with only this code inside:
<%Response.Write now()%>
As a result, if I go into the IE and browse for the test.asp page, I get :
1/22/2004 14:18:04
If I copy this page on some other(existing) virtual directory, I get as a
result 22.1.2004 14:19:06
If I create a new virtual directory and I copy the page there, I get :
1/22/2004 14:18:04
Seems like that IIS takes english date format even if my regional setting is
:
d.M.yyyy and I would like that date on the page is always like this:
22.1.2004 14:19:06
Where I can change this setting?
View Replies
View Related
Within ASP, the date is given in a format like:
6/23/2004 (independantely of the regional settings of windows).
I would like to have e.g. 23/06/04.
Is this possible ?
View Replies
View Related
I am trying to change a short date format in windows.regionalSettings, and all changes affect only client scripts but server side scripts not
regionalSettings = dd/mm/yyyy
asp code result
response.write(Date) '03/03/1983
regionalSettings = dd.mm.yyyy
asp code result
response.write(Date) '03/03/1983
View Replies
View Related
I have written various scripts where the date is enter as mm/dd/yyyy. However, they wanted changed to dd/mm/yyyy. How can make these changes with less pain?
I am using an Access Database. Which means, I will probably have to program that field the same way. But the only option it provides is something like "29-Sep-05". I can tell the user to enter the field as mm/dd/yyyy. But how can I have it done with the code to be saved on the database.
This is one of my codes:
rs("approval_date") = Request.Form("approval_date")
View Replies
View Related
i have a date stored in my db in this format: 2005-03-15 00:00:00.000
however, i want to display this date on my .asp page in this format: 03/05
is there a quick function to do this?
View Replies
View Related
i am having the dd/mm/yyyy format in my computer. i have done coding in asp page according to it. but when i run the same asp pages in different machines it shows me undesired results. so how do i change different machines settings also to dd/mm/yyyy format.
View Replies
View Related
Anyone who can help me with a code to convert a date string to another format?
Today the format is like this: 2005-01-12T10:06:42.8130000
I want to change it to this format:12.01.2005 12:06:42 (mm.dd.yyy tt:mm:ss)
I can`t use any fancy server tools, just plain asp-code that I can implement in my existing files. The date is a text string - and should be convertet using a little codes as neccessary.
View Replies
View Related
My asp pages that display data from databases have suddenly changed the date format they display from UK to US, i.e. 11/17/2001 for 17th Nov 2003. I have checked on the win2k sp3 server that they run on, and the date/time zone is GMT UK and also the regional settings are correct for the UK.
The server has been patched in the last couple of weeks, but I'm not sure which patches as various engineers have access to it. However, does anybody know why this should happen when all the date/time settings are correct for the UK format?
View Replies
View Related
I need to update an oracle database however, i must have the format
22 FEB 2004
Unfortunately i use a date picker(javascript) which returns 22/02/2004.
(this happens in client side)
How do i change the format to "22 feb 2004" in the server before inserting into the database ?
I already have
strdate1 = Request.Form("date1")
how do i change this date format ?
View Replies
View Related
the date format in my database(ms access) used to be mm/dd/yyyy and i've changed to dd/mm/yyyy. Now the date appears fine in the db. however wen i retrieve the data and displays in on a form, it is back to it's default format(mm/dd/yyyy). is there anyway whereby i can change it?maybe something like FormatNumber(rs("FromDate")) or whatsoever?
View Replies
View Related
In my db, I have a date field wich as the format yyyy-mm-dd but when I receive the value from the DB, I'd like to change it to dd-mm-yyyy... How can I do this?
View Replies
View Related
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies
View Related
I have this is my code:
<%= linkRec("datein")%>
It displays the date like this: 12/14/2004
But I need it to display like: Dec 14, 2004 or something similar (not just numbers)
Is this possible?
View Replies
View Related
This is regarding a change in the Short Date format under Hebrew Regional
Settings, that has caused huge problems in our ASP web application. The
change appears to have been introduced sometime before Windows 2000 Service
Pack 4 and has remained through to Windows XP. I am looking for a solution
that doesn't involve rewriting our application (much) and that allows all
our users to keep using Hebrew Regional Settings.
To summarize our problem - we have an ASP-based intranet web application
that is used in our Israel office. Before we installed Windows 2000 SP4 on
our web server and on the client machines in the office, the application ran
perfectly. Dates appeared on the pages and in input textboxes in the correct
dd/mm/yyyy format. Immediately after installing SP4, dates on the pages and
in input textboxes are formatted as yyyy/mm/dd. This is not just a visual
change, it has caused many functions in the application to break. Code:
View Replies
View Related
I am trying to create a form and I have looked on the forums and couldn't find anything like this.
Situation.
I want to convert example S.S. number from this
123-45-6789
to this
XXX-XX-6789
How can I do this in ASP?I tried a replace function but doens't work or I have it completely wrong format
View Replies
View Related
This seems to be a pretty basic question, but I can't find the answer. In
VB I format a number by: format("1234", "#.00") (result: 1234.00)
This doesn't work in asp, I get an error. How do I format numbers?
View Replies
View Related
I want to be able to format a phone number to add the spaces.
Input 0234787655
Change to : 02 3478 7655
how possible is this ..
View Replies
View Related
on one of my web page, i have a number field for percentage. the value for this field is decimal. i want the value to be in ##,## format no matter what the regional settings are.
the value will be saved to database whose format depends on regional settings. i use sql server 2000. how can i do that?
View Replies
View Related
I am using asp with access db on ms server.total_score is my field from a table within the db., I wish to format this to show commas, but no decimal. Rounding in other words. What is the code for this please, can someone show me?i know it is something like var = format(total_score,0,0) or something to that effect.
View Replies
View Related
How do I format a specific string and add dashes inside the string. The output I get from the recordset, for example, is 007275153. I want to format the output as 00-727-5153.
Also, if a string in a database is C-1411C1, how can I remove the "C-" at the beginning of the string?
View Replies
View Related
Does anyone have and easy way of modifying the format of a number once pulled from an Access database? In the thread listed above, Access is stripping the 0's in front of my numbers. As a work around I have an If statement that checks to see if the number is < 10 and if so write a 0 before pulling from the recordset. I'm looking for a simpler, one line code instead of the big If statement.
View Replies
View Related
It shows the data but not like in the data table (Access). I would like that the numbers have a 2 digit decimal behind the comma i.e.123.456,30 and negative numbers should be in red and in brackets i.e. (123.456,30) So, the format should be:
$#.##0,00;($#.##0,00)[Red] as I have done it in the table - but not in ASP
Where do I have to enter the format in the ASP code? - or - Where do I have to enter the format in the Html code? Is someone able to write me the coding line?
View Replies
View Related
i need my field that is 10.00 and turn it into this 00001000 any ideas.
View Replies
View Related
I have an access database with a table called jobs with a field called 'jobnumber'. I have this set up with a format mask of "0000" so that "1" becomes "0001" etc.
However when pulling this data out in Dreamweaver the formatting is lost.
Does anyone know how I can set this in Dreamweaver?
View Replies
View Related
I have a 20 character string that I need to format in a certain way. For instance, here is the raw string:
12345678901234567890
And I need it to look like this:
123-45-6789-01-234-5-67-8-90
It wouldn't bother me if the number was entered into a text box without any dashes, but then before I submit the number to the db I would need to enter the dashes in the correct spots. Can anyone give me an idea of how I can accomplish this?
View Replies
View Related
I have a combo which has 2 values.I want when its value is changed then its value should be display in a text box.
View Replies
View Related
I would like to know if I can change the text value of an item in javascript ie:
<script language='javascript'>
function restore_BG(the_Id) {
if (the_Id == 'Arts') {
document.getElementById(the_Id).??? //what code needs to be here to change 'Hallo' to 'Bye' for eg.
}
}
</script>
<tr onmouseover="javascript:restore_BG('Arts')">Hallo</tr>
View Replies
View Related
I have a access database that has data where the people entered their name all in upper case or in various forms of upper and lower case. Can a change all the data so it is in a proper format. Example: This is Joe Smoe. Or change it to be all lower case for email addresses?
View Replies
View Related
I have 10 text boxes... first 5 text boxes e visible , rest of the 5 are hidden... once i clicked the button , the hidden boxes should be visble.. can anyone help me hpw to write script?
View Replies
View Related
i have three images on my page which i want to be able to increase the text size of the whole page by using these buttons
Small Normal Large
Standard size will be normal, the others i want to affect the whole site so when they change page the setting changes stay with them
The only way i can think of is multiple style sheets and saving to a cookie anyone got some examples or suggestions / solutions for how to approach this ?
View Replies
View Related
In a form I'm creating several asp text boxes for user input. When I look at these in IE or Firefox one or two are coloured yellow with a border, whereas the rest are the normal white with a thin blue border.
There is nothing I can see in the code that does this, and with a bit of testing I can force this condition by adding text outside the text box. Very weird. Has anybody seen this behaviour before. I'm using Dreamweaver MX 2004, but I'm feeling it's not DW at fault here.
View Replies
View Related
I want to change the text color of the input box depending on the value entered by user.
View Replies
View Related
