| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
invoice amounts in 2 columns?
on my paper invoice, it has 2 distinct columns. I can only have a figure like
38.50 (in excel) not 38 50 to show up in the 2 separate columns but still be still classed as one number in excel so i can do formulas etc! any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
invoice amounts in 2 columns?
can't you just add the numbers together in your formulas 38 + (50 / 100) and use that? -- baxybaxy ------------------------------------------------------------------------ baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824 View this thread: http://www.excelforum.com/showthread...hreadid=556011 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| missing invoice toolbar when save customised invoice | New Users to Excel | |||
| matching dupliclates and then looking up the corresponding amounts | Excel Discussion (Misc queries) | |||
| Master invoice number | Excel Worksheet Functions | |||
| VB copde help - please! | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Linear Mode
