HELP ME PLEASE ---- COMPUTERS ARE STARTING TO FLY!

[kathleen]

I have a web page (I created it in the so called compatiable product of FrontPage ) that's using an Office Component to deliver a Office Spreadsheet. When the user views the page they see an edit with Excel option.

My problem is that it is delivering the Spreadsheet in text format. One of the columns is formatted in Currency. I can strip the $ out and the commas out but Excel is still treating it as text. There is a space at the end of the field that I can not eliminate. Any clues?

 

[Royal Presence]

What I do with Excel, is when in FP, insert web component, (spreadsheet), then there are options for interactivity, etc....
Once the excel format is in your page, paste the data from your spreadsheet. You don't have to change from tab delimited or anything.
In original ss, format cells as just currency.
It worked from here. Then all I do is save, since I publish live.

Let me know if I need to explain it better, I'm not that good at transferring my brain to words sometimes.

I can send a url for an example, if you give me some data to use as a sample.

 

[kathleen]

No problem. :wink: I might be just a little overly sensitive right now, frustatration level is very high! As you can probally tell by subject. I really do appreciate your help!

 

[kathleen]

Thank you I can't find the options for interactivity. Is this due to the fact that the data is being inserted via a SQL Query and ASP?

 

[Royal Presence]

Not sure, but in 2002, I don't think you need to select interactive, because it includes alot of basic features. However, you can click the icon at top right or right click on your mouse for additional options. Did it work for you?

 

[kathleen422]

Really appreciate everyone's help. Had to leave the office, just couldn't deal with this anymore today. Will pick up again on Monday morning.

Thanks Again

 

[Royal Presence]

Okay- let us know. I tried it again with my data and worked great, so I'm sure you can make this effective.

 

[just_jon]

Kathleen -- have you tried applying the TrimAll to your data?

 

[kathleen]

Hi all. Back to this. I do not have a TRIMALL Function.

I have tried formatting the cells within the Office Component to no avail.

When the recordset returns the amount I am receiving a $1,038.55 in the Spreadsheet. I have used a find and replace to eliminate the $ and comma, leaving me with 1038.55. If I check the len of the result I am told it is 8 chars long. If I do a MID on that cell and pull out the 8th Character I obtain a space yet when I do a CHAR to obtain its value I am presented with a #VALUE. When the recordset is writing the data to the spreadsheet it uses the   to allow for a space so the tables are shown for all rows. Does anybody know what the ASCII value for   is?

 

[kathleen]

Post is stripping out reference ampersandnbsp;

which is showing up on screen as a space

 

[just_jon]

I put the TrimAll macro on the 1st page of this thread -- do you need help in installing it?