Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Frank,
I tried General as well still doesn work. Issue is Excel somehow throws in the single quote in the begining .. If i can find a way to stop excel from doing that i am good to go... Any idea is appreciated "Frank Kabel" wrote: Hi you have to set the format to 'General' before inserting your values -- Regards Frank Kabel Frankfurt, Germany "Sujith Kumar" schrieb im Newsbeitrag ... Hello Frank... Excel sheet is created by a program (SQL DTS routine) Presently this field is text. What esle i should use? Thanks "Frank Kabel" wrote: Hi how are you inserting this formula? Also check that this cell is nOT formated as 'Text' |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Hyperlinks | Excel Worksheet Functions | |||
Dynamic hyperlinks | Excel Discussion (Misc queries) | |||
Dynamic hyperlinks problem | Excel Worksheet Functions | |||
problem with Hyperlinks to XL Docs from within Excel | Excel Discussion (Misc queries) |