Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

Number Formatting Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lee Harris - 23 Nov 2005 12:39 GMT
I have a CSV file, and it must remain a CSV file because I use it to bind to
a DHTML page using a data source object.

I have a column in there called "salary", but I want it to be listed to 4
decimal places, ie 1.6700 not 1.67

I've formatted it in Excel that way, but on the web page it's always showing
as 1.67, I then tried a trick by storing it as a float for sorting purposes,
but as text for display purposes but that didn't work either

how can I do something like

B1 = Concatenate(A1) to turn the value in A1 into text, but retaining the
trailing zeros required

by the way, when I open the CSV file in notepad the numbers are in the right
format, so it's a DHTML issue to display them, but if I can get this trick
to work storing a duplicate as text, it won't matter, I'll get the web page
to display the text version but use the numeric version to sort/rank

thanks
Lee
Rob Hick - 23 Nov 2005 13:06 GMT
You could try using

=TEXT(A1,"0.0000")

as the formula.  I'm not sure how this would come out in CSV though.
Lee Harris - 23 Nov 2005 14:56 GMT
> You could try using
>
> =TEXT(A1,"0.0000")
>
> as the formula.  I'm not sure how this would come out in CSV though.

cheers, that works a treat
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.