Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type - help me to solve this
A1 content is '02/9085 but when I run the under mentioned program I
always get 01/02/9085 (feb-85), can anybody pls help me to keep the data the way they are. Sub Test() Dim a As String a = Range("A1").Value Range("A1").Value = a End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type - help me to solve this
One way:
Sub Test() Dim a As String a = Range("A1").Value Range("A1").Value = "'" & a End Sub "'" : single quote between 2 doouble quotes. -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please. "choco140" skrev i en meddelelse om... A1 content is '02/9085 but when I run the under mentioned program I always get 01/02/9085 (feb-85), can anybody pls help me to keep the data the way they are. Sub Test() Dim a As String a = Range("A1").Value Range("A1").Value = a End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
solver can not solve polynomial eq. where one variable is five di. | Excel Worksheet Functions | |||
User Defined Type Structure - want it to be variable not numeric literal | Excel Programming |