Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW DO I FORMAT A CELL TO COME UP WITH ‚¬ £ $
i have a spread sheet with different currencies and I want to know if i can
format one column so that the different currency symbol comes on an amount i enter. i know i can format from the format box but was wonder if there is something i can enter so that the currency symbol comes up automatically. i have a lookup table on sheet two with the currency symbol against 20 products. can i incorporate this currency symbol in the cell when i enter the amount on sheet 1. thank you for your help |
#2
|
|||
|
|||
Hi BAZZA,
i have a spread sheet with different currencies and I want to know if i can format one column so that the different currency symbol comes Format/Cells/Number select "Currency" and "Symbol". Check if it's printed correctly on your printer. Otherwise use USD, EUR etc. arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
format cell for figures - Ajit | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |