Hi I'm new here and hope someone can help me.
I have a basic spread sheet and what I need to do is change the font size of a value. eg £100.99 I want the £ to be maybe 10points size 100 to be 70point size and .99 to be 10points size. for example £100.99.
then the contents of this cell to be duplicated in a text box.
hope this makes sense
thanks in advance
I'm gonna stick my neck out here and say you can't do that. You could however split the "£", "100", ".99" up into three cells and format each of the cells into different font sizes. If anyone has a solution to this I'm sure they will correct me :-)
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.
You can do it only if the data is manually entered and formatted as text.
Entia non sunt multiplicanda sine necessitate
thanks for you answers guys ....but sigh thought it would be easier than that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks