Hi,
I am currently working on a spreadsheet and I need to keep the formatting of another cell.
is what I am currently using, but instead of putting in £1.00 it put in £100.
Please Login or Register to view this content.
Could anyone help me to get this right?
Thanks
What's in B8, what's in B10?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
In B8 I havethis pulls the first 3 letters from a cell on another sheet.Please Login or Register to view this content.
In B10 I haveThis brings in the amount of money.Please Login or Register to view this content.
Hi there. try this out:
=CONCATENATE("Sheet to "&B8&" £",TEXT(B10,"######.00"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi,Originally Posted by Glenn Kennedy
This makes £1.00 show as £100.00
How many dps do you want?
Just one. But I need it to know if it is below 2 figures, and not just change it to £100
What I posted makes 1.00 appear as 1.00. How is that wrong??
When I put that in the formula bar, It shows £100.00.
If you want one...
="Sheet to "&B8&" £"&TEXT(B10,"0.0")
!! Not on this side of the Irish Sea it doesn't!! How is the cell formatted... he said, clutching at straws...
General formatting, honestly that is what it shows. I think it may be because it is pulling data from other cells that are also pulling data in.
Waddya see here???
I have attached an example.
example.xlsx
The value in Template E6 is not 1, but 100!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks