|
|
|
|||||||
| Notices |
 |
|
|
Thread Tools | Display Modes |
12-08-2009, 03:49 PM
|
#1 |
|
Newbie
Join Date: Jun 2009
Age: 24
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
 OS:
|
Set excel cell format to string
Hi all!
I have a little problem. I trasfer data to an excel worksheet. The data is integer, and start with 2 zeros: example: 00231441 Its working, but when the script load these numbers into the worksheet, it cut the zeros. But if the cells format is string, it is working fine. So, I would like to set the cells format to string in the excell workshhet with PowerShell! If you coild help me, pls write! Thanks! Koky |
|
|
|
12-08-2009, 11:28 PM
|
#2 |
|
Newbie
Join Date: Feb 2006
Age: 26
Posts: 8
Thanks: 1
Thanked 4 Times in 3 Posts
Rep Power: 3
 OS:
|
Re: Set excel cell format to string
limited custom setting are there in xls, better write a function(fx) for the required columns
|
|
|
|
|
13-08-2009, 01:56 PM
|
#3 |
|
Newbie
Join Date: Jun 2009
Age: 24
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
OS:
|
Re: Set excel cell format to string
Thanks the reply!
Yes, I see there are just limited custem settings. Maybe a function will help! But How shall I write this function? I dont know how I can solve that the format type of the excel cell shall be string. If you, or somebody know a solution to this pls write! Or the other side of the problem: How can I write an integer into an excel cell with PowerShell without cutting of the zeros from the front of the number? Thaks in advance! |
|
|
|
|
18-08-2009, 02:25 PM
|
#4 |
|
Newbie
Join Date: Jun 2009
Age: 24
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
OS:
|
Re: Set excel cell format to string
Anybody any idea?
Please help me! I have to solve this problem! I have already searched the solution sience days..but nothing. Any idea? |
|
|
|
|
| Tags |
| excel, powershell |
| Thread Tools | |
| Display Modes | |
|
|
< Windows Help - MS Office Help - Hardware Support >
| New To Site? | Need Help? |
Linear Mode
