Windows 7 Support
Become a Fan of PCHF on Facebook!
User Reviews - Add Yours!
The PCHF Lounge
Go Back   PC Help Forum » Software » Office Software
Register for a Free Account

Office Software - Ex\el 2003 'in cell' formats posted in the Software forums; I am trying to find how i can edit text and formaulas in a single cell. for example A1 - 10000 A2 - 3 A3 - ="The answer to the ...

Advertisement
Advertisement

Reply
Free PC Performance Scan
Old 03-16-2009   #1
New Poster
 
Join Date: Mar 2009
Posts: 2
PC Experience: Very Experienced
Default Ex\el 2003 'in cell' formats

I am trying to find how i can edit text and formaulas in a single cell.

for example
A1 - 10000
A2 - 3

A3 - ="The answer to the question is " & A1/A3

this will give the result "The answer to the question is 3333.333333

if i change it slightly to
="The answer to the question is " & round(A1/A3,0) I get ......3333

but I would really like get .........3,333
is there an equivalent function like FORMAT(xxxx,"0,000")?
can anyone tell me how to do this?

thanks

john
jmaserati is offline   Reply With Quote
Old 03-16-2009   #2
New Poster
 
Join Date: Mar 2009
Posts: 2
PC Experience: Very Experienced
Default Re: Ex\el 2003 'in cell' formats

found it
="blah blah blah " & text(a1/a3,"#,##0")
jmaserati is offline   Reply With Quote
Old 03-17-2009   #3
Wandering Cruncher
 
LoneWolf's Avatar
 
Join Date: Sep 2008
Location: Kelowna, BC
Posts: 1,370
PC Experience: Experienced
Default Re: Ex\el 2003 'in cell' formats

Welcome to PCHF jmaserati.


I guess that was an easy thread to tend to.
LoneWolf is online now   Reply With Quote

Reply

Bookmarks

Tags
2003, cell, excel 2003, exel, fomatting, formats, question, Resolved, Resolved:
Similar discussions...
Thread Thread Starter Forum Replies Last Post
Solved: what are the dvd video file formats ? davesam General Software 3 01-04-2009 05:41 AM
Pending: About burning DVD formats EathanElf CD & DVD Burning 4 06-23-2008 08:17 PM
Solved: Hard Drive Formats?? LittleKidfromMars Hard Drives 11 01-08-2008 04:33 AM
Office 2003 SP3 Disables Legacy File Formats + Registry Fix Hengis Office Software 0 01-06-2008 06:56 PM
Information: What do all the different audio formats mean and what do I do if my computer won merlin Windows Tutorials 0 08-01-2005 04:10 AM

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On




All times are GMT. The time now is 10:38 PM.
Powered by vBulletin
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2